Start Free Trial

Alteryx Designer Desktop Discussions

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

Counting days in between two dates

maddoxs
7 - Meteor

I am having trouble calculating a "days past due" between two dates 

For example, 11/01/23 and 11/05/23 - I am wanting to calculate the days in between those two in a new column

Thank you in advance!

2 REPLIES 2
maddoxs
7 - Meteor

DateTimeDiff([Date Received],[Document Date],'Days')

Would a formula like this work?

binu_acs
21 - Polaris

@maddoxs you need to convert the dates into ISO format

image.png

 

Labels
Top Solution Authors