Convert Date to Number

[Neeta_Latwal]

Hi All,

Please help me alteryx tool:-

Date	Number (desire result)
2023-01-11	44,937.00
2023-01-03	44,929.00
2023-01-27	44,953.00

Thanks,

[AngelosPachis]

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]

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

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

can help.