INT() Function used in Excel converted to Alteryx

[gavinloi_]

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]

@gavinloi_ have you tried tointeger()?

[gavinloi_]

Hi @aatalai the tointeger() function seems to be giving me a Parse Error unknown function. is there a way to use it ?

[aatalai · Accepted solution]

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

[binuacs · Accepted solution]

@gavinloi_ 

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