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

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
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

Labels (1)
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