How can I convert Date to General format?

Hi All,

I am new to Alteryx and trying to convert [Date] to General format we have in Excel.

As an example we have 43862.0028140046 as general form of 01/02/2020 00:04

Basically I am looking for [Date]-INT[Date], can you please advise for Int function aswell?

Date Time

Accepted answers

you can achieve something like this using DateTimeDiff in the Formula Tool.

DateTimeDiff('2020-03-25 18:37:00','1900-01-01 00:00:00', 'Minutes')/(24*60)

Let me know if this helps.

Alex

you can achieve something like this using DateTimeDiff in the Formula Tool.

DateTimeDiff('2020-03-25 18:37:00','1900-01-01 00:00:00', 'Minutes')/(24*60)

Let me know if this helps.

Alex

Thank you, It works.