Convert Number to Date Format

[bubblyjai1982]

Hi All,

Need your assistance, looks like I'm missing something.

I have dates in number format (String type) tried using formula or the Date Time tool and then convert back to desired format but not able to get the correct output.

Tried using below formula but not working, looks like this is incomplete.

DateTimeParse([Date],"%b %d %Y %I:%M%p")

OR

DateTimeFormat([Date],"%m.%d.%Y") 

Date

45576

45581

45582

45573

45580

The desired out looking as yyyy-mm-dd

Please help

Best Regards

[binuacs · Accepted solution]

@bubblyjai1982 try the toDate(toNumber([Date])) function

[bubblyjai1982]

Perfect !! Thank you