Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I receive a date with that format (YYYYDDD) where DDD is the number of the day of the year.
(002 meaning 02 January, 032 meaning 01 february).
Is there any way I can create a "Real Date" with a format like YYYY/MM/DD ?
Thanks for your help.
Philippe
Something like:
=Date(MakeDate(YYYY) + DDD)
That will take the number of days added to January 1st of the year, to get the date.
Something like:
=Date(MakeDate(YYYY) + DDD)
That will take the number of days added to January 1st of the year, to get the date.
Try this:
Date(MakeDate(left(Date, 4))+(right(Date, 3))) as RealDate
Thanks a lot !!!!
Philippe