PDA

View Full Version : Solved: Text to Number



bkudulis
05-15-2005, 02:40 PM
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
05-16-2005, 01:56 AM
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
05-25-2005, 06:45 AM
This is exactly what I was looking for thank you.

Anne Troy
05-25-2005, 08:08 AM
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!