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)