How can I convert a week number to a month?

  • Thread starter Thread starter gendean
  • Start date Start date
G

gendean

Guest
Help!!
I have 2 fields in a table one for a year and one for a week number that data is being collected against.
I need to change these to a month and year for the report. Is there a way to do this??
 
Try DATEADD from 1/1/2005 and extract the month?
 

Users who are viewing this thread

Back
Top Bottom