INT() Function used in Excel converted to Alteryx

Question

Hi all, can I check is there a function that I can use to convert "2024-01-25" to 45316 (which is the number of days that elapsed from Jan 0, 1900).

I have tried to use the TONUMBER but I am getting "2024" instead.

In excel, I would be able to use INT()

Any help is much appreciated.

Thank you

aatalai · Accepted Answer

sorry misread your question try the formula tool DateTimeDiff([EndDate],Jan 1 1900 (you need to conver that into date format, 'days').

binu_acs · Accepted Answer

@gavinloi_

DateTimeDiff([Date],'1900-01-01','days')+2