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
16 - Nebula
16 - Nebula

Max([Date1],[Date2])

Raj
14 - Magnetar

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

Labels