Alteryx Designer Desktop Discussions

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

Working out how many days between 2 dates

binsell
8 - Asteroid

Hi All - I have tried a formula to work how how many days there are between two dates but keep failing. My data type for my dates data is a 'date' and in this format 2022-09-19.

Could someone kindly give me a formula to work out how many days are between these two dates please; 2022-09-19 and 2023-09-18 - Thank you in advance! 

3 REPLIES 3
Raj
16 - Nebula

DateTimeDiff([Field1],[Field2],"days")

@binsell please use this formula


mark done if solved.

Raj
16 - Nebula

@binsell 
workflow attached for reference

hope this helps.

binsell
8 - Asteroid

You are on fire Raj! Thanks for always replying to my posts! :)

Labels