Please assist in conversion of date problem

[WhiteZiggy]

I have the day. IE "365". I need to convert it to the month and day. Ie "December 31" .. Or "1" ie "January 1".

Does anyone know of any expressions to assist in this?

Thanks,
Ziggy

 

[SkipVought]

Hi

To be a date you must add the DAY value to a BASE DATE.

For instance

DAY = 356
BaseDate = 12/31/2003
NewDate = BaseDate + DAY

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884

Skip,

http://www.TheOfficeExperts.com

 

[WhiteZiggy]

Thanks a bunch. That will make this much easier.