how to enter this formula in alteryx =IF(E22=G22,TRUE,IF(G22>E22,"CR_Earlier","CR_Later"))

[nmahmood91]

Hi All, 

I am trying to re-create this formula in alteryx 

=IF(E22=G22,TRUE,IF(G22>E22,"CR_Earlier","CR_Later")) 

If dates in two different columns are the same, then I would like a new column to return "MATCH" if dates in one column are earlier than the other i would like the new column to return "CR Earlier" and if they are not then "CR Later" 

30/11/2023  30/11/2023
31/08/2024  31/08/2024
25/01/2025 25/01/2025
11/01/2024  01/11/2024
31/03/2024  31/03/2024
31/12/2024  31/12/2024
14/02/2025 14/02/2025
14/06/2025  14/06/2025
30/06/2025  30/06/2025
29/06/2026  29/06/2026
30/09/2023  30/09/2023
03/11/2024  11/03/2024

[Sreevidya7]

Hi

Please find the attached the workflow with formula.

[aatalai]

@nmahmood91 some intial formatting was needed, but you might be able to jump straight to the formula tool. hope this helps

[mgaronson · Accepted solution]

In Alteryx, convert date columns to date data type.

Formula - new column 'Date Check'

IF [Date 1 Out] = [Date 2 Out]
THEN 'Match'
ELSEIF [Date 1 Out] > [Date 2 Out]
THEN 'CR_Earlier'
ELSE 'CR_Later'
ENDIF

 

[nmahmood91]

Thank You so much!

[mgaronson]

Please upvote all solutions.