Hello!
I have 3 dates: Date1, Date2 and Date3. All dates are formatted MM/DD/YYYY and I would like to keep them in this presentation.
I am trying to use an if statement to say if Date1 <= Date2, then Date3 - Date1, if not 0. Can someone please help me put this into the correct formula for Alteryx? I always have a hard time with formulas involving dates.
Thanks in advance!
Hey @lindsayhupp,
It would be good if you could provide a sample dataset.
And to find the difference between two Dates, you can use DateTimeDiff().
Link to all DateTime Functions - https://help.alteryx.com/20221/designer/datetime-functions
Regards.
Hi @lindsayhupp,
To use date time functions the data needs to be in yyyy-mm-dd format.
For what you're trying to do, something like the below should work (like @allwynthomas24 said sample data is always helpful).
IF DateTimeParse([Date1],'%m/%d/%Y') <= DateTimeParse([Date2],'%m/%d/%Y')
THEN DateTimeDiff(DateTimeParse([Date3],'%m/%d/%Y'),DateTimeParse([Date1],'%m/%d/%Y'),'days')
ELSE 0
Endif
@lindsayhupp
When I was about to post, @Luke_C has given the same solution.
But I will just post it any way.
For the date time functions, I always go though the help file, which is really helpful for me.
https://help.alteryx.com/20221/designer/datetime-functions
I got it to work. Thank you you so much!