Date format Issue

[#1]

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

[#2 · Accepted solution]

Something like:

=Date(MakeDate(YYYY) + DDD)

That will take the number of days added to January 1st of the year, to get the date.

[#3]

Try this:

Date(MakeDate(left(Date, 4))+(right(Date, 3))) as RealDate

[#4]

Thanks a lot !!!!

Philippe