Convert Day of Year to date

[AKMonkeyboy]

I have a field that contains what day of year it is i.e.:

Feb 2 = 33

Is there a function to turn the "33" back into Feb 2?

I'm stumped...

Monkey

Give a man a fish, and you feed him for a day.
Teach a man to fish, and you feed
him for life.
Send a man to Tek-Tips and the poor sap can find out how to fish on his own, and learn more by doing it.

 

[Golom]

DateAdd ("d", 33, #12/31/2006#)

 

[PaulBricker]

This will give you what you want.


DateSerial(Year(Date()),1,1)+33


Paul

 

[PaulBricker]

Oops.

DateSerial(Year(Date()),1,0)+33

Read my results backwards.

Paul

 

[Golom]

Paul

I think that needs to be

DateSerial(Year(Date()),1,[red]0[/red])+33

 

[AKMonkeyboy]

Try and get an answer a little faster next time, would ya? I'm tired of waiting 6 minutes for answers

Amazing! Works like a charm. Thanks to all!

Monkey



Give a man a fish, and you feed him for a day.
Teach a man to fish, and you feed
him for life.
Send a man to Tek-Tips and the poor sap can find out how to fish on his own, and learn more by doing it.

 

[lespaul]

you're right MonkeyBoy, Golom's usual reply time is probably less than 5 minutes, he must be slacking today!



leslie

 

[PHV]

Why not simply this ?
DateSerial(Year(Date()),1,33)

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886