Solved: Text to Number

[bkudulis]

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)

[Bob Phillips]

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)*1

or

Val(Format([Actual_Shift_Start_Dt],"ww",7))

[bkudulis]

This is exactly what I was looking for thank you.

[Anne Troy]

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!