Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Independent validation for trusted, AI-ready data integration. See why IDC named Qlik a Leader: Read the Excerpt!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Date Comparison

Hi

I have two dates. Start Date and end date,

I need to write a logic

if(Start Date> End date ) then

date = Start Date

else

date = End Date.

Kindly assist in writing the expression

2 Replies
effinty2112
Master
Master

Hi Manpreet,

Try:

Date = RangeMax([Start Date],[End Date])

Regards

Andrew

pathiqvd
Creator III
Creator III

if(Start Date>=End Date,Start Date,End Date)  Check this