Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.
Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

How can I convert Date to General format?

Nargess
7 - Meteor

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? 

4 REPLIES 4
grossal
15 - Aurora
15 - Aurora

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
7 - Meteor

Thank you, It works. 

grossal
15 - Aurora
15 - Aurora

That's great!

 

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

Nargess
7 - Meteor

sure, Many thanks.

Labels
Top Solution Authors