How can I convert Date to General format?

[Nargess]

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? 

[grossal · Accepted solution]

Hi @Nargess,

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

[Nargess]

Thank you, It works. 

[grossal]

That's great!

Can you accept it as a solution so others can find it more quickly?

[Nargess]

sure, Many thanks.