I am using the following function to convert a date to a week of the year. The makes the result into text which I would like to have it as a numeric value. How do you convert it?
Format([Actual_Shift_Start_Dt],"ww",7)
Printable View
I am using the following function to convert a date to a week of the year. The makes the result into text which I would like to have it as a numeric value. How do you convert it?
Format([Actual_Shift_Start_Dt],"ww",7)
Format([Actual_Shift_Start_Dt],"ww",7)*1Quote:
Originally Posted by bkudulis
or
Val(Format([Actual_Shift_Start_Dt],"ww",7))
This is exactly what I was looking for thank you.
Nice, xld. :)
bkudulis: I've marked this solved for you. Next time, you can just hit Thread Tools at the top of the page and mark it solved yourself. Thanks!