Date Format issue

[AKPWZ]

Hi again,

Trying to solve a date format issue that I encountered today, I would really appreciate it if someone could tell me what 45021.28263 is and how to change it to 3/31/2023 15:03:07.

Thank you

[binuacs]

@AKPWZ I am getting a different date value

[Qiu]

Excel shows a bit different also.

[PhilipMannering · Accepted solution]

You can also do,

ToDateTime([Date])

[anandakrishnan]

@binuacs 

👍

[caltang · Accepted solution]

Using ToDateTime(ToNumber([Date])) gets me this result.