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)
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)*1Originally Posted by bkudulis
or
Val(Format([Actual_Shift_Start_Dt],"ww",7))
____________________________________________
Nihil simul inventum est et perfectum
Abusus non tollit usum
Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
James Thurber
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!
~Anne Troy