In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

Alteryx Designer Desktop Discussions

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

INT() Function used in Excel converted to Alteryx

gavinloi_
7 - Meteor

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

4 REPLIES 4
aatalai
14 - Magnetar

@gavinloi_ have you tried tointeger()?

gavinloi_
7 - Meteor

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

aatalai
14 - Magnetar

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

 

 

binuacs
21 - Polaris

@gavinloi_ 

DateTimeDiff([Date],'1900-01-01','days')+2
Labels
Top Solution Authors