Comparing Two Dates

Question

Hi all,

I'm trying to compare two dates in the attached file ("Date 1" and "Date 2")

If Date 1 is before Date 2, I would like to show it in the output and if Date 1 is after Date 2, I want to exclude.

For example, in the first row, Date 1 is 30th May 2024 and Date 2 is 15th Feb 2023. Therefore, this can be excluded.

Wondering if anyone could help me with this?

Thanks in advance!

Date Comparison.xlsx

JosephSerpis · Answer

Hi @AlteryxLearner23 the screenshot below will explain what I mean about ISO format.

AlteryxLearner23 · Answer

Thanks @JosephSerpis - what do you mean when you say that I need to convert the dates to an ISO format?

JosephSerpis · Answer

Hi @AlteryxLearner23 you can do this within a if formula comparing if date  1 is less then date 2 then outputing to a new field which I assumed you were asking for in output. Due to the format of your dates they do need to be converted to a ISO format in order to compare the dates.

Compare_Dates_06072023.yxmd