Alteryx Designer Desktop Discussions

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

Find the later date between two columns (columns may be null)

wonka1234
10 - Fireball

Hi,

 

Say I have this, how can i generate the result column?

 

Date1Date2Result
2024-02-022024-02-012024-02-02
2024-02-142024-02-152024-02-15
2024-02-21null2024-02-21
null2024-03-302024-03-30

 

thanks.

2 REPLIES 2
alexnajm
17 - Castor
17 - Castor

Max([Date1],[Date2])

Raj
15 - Aurora

using Formula tool
Max([Date1],[Date2])

Labels