Finding a date

[BigJimSlade]

Hello, Big Jim here,

Ok, say I have a number from 1-365 (I had to build an array to group data by each day of the year.

I need to convert that number 1-365 back to the month and day of month. How would I do this?

Thanks in advance,

Big Jim

 

[Keith P]

First get the date by starting at January 1 for whatever year and adding the number of days, e.g. myDate = #1/1/2001# + myNumber
Then use the DatePart function if you need elements of the date.
Hope this helps.

 

[BigJimSlade]

Keith,

Thanks for your help. Worked great!

Big Jim