In case you missed the announcement: The Alteryx One Fall Release is here! Learn more about the new features and capabilities here
ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests after December 31, 2025. Set up your security questions now so you can recover your account anytime, just log out and back in to get started. Learn more here
Start Free Trial

London, UK

Welcome to the London User Group

Click the 'Join Group' button to get updates on group news and events.

Convert Date to Number

Neeta_Latwal
7 - Meteor

Hi All,

 

Please help me alteryx tool:-

 

DateNumber (desire result)
2023-01-1144,937.00
2023-01-0344,929.00
2023-01-2744,953.00
  

Thanks,

2 REPLIES 2
AngelosPachis
16 - Nebula

Hi @Neeta_Latwal ,

 

In a formula tool, try:

 

DATETIMEDIFF([Date],"1899-12-30","days")

 

If you subtract the numbers you provided from the [Date] column, they all give "1899-12-30' as the result, which is your start date. So just reverse engineer that

Varad_Paranjape
6 - Meteoroid

If this is the Excel type format that you are looking for then 

TOSTRING(DATETIMEDIFF([datefield],'1900-01-01','days'))+TOSTRING([numberIDField])

can help.  

Top Liked Posts