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

Announcements
Talend Cloud AWS EU Scheduled Outage: Starting Tues 26 May 21:00 CEST with expected completion Wed 27 May 01:00 CEST
cancel
Showing results for 
Search instead for 
Did you mean: 
soha1902
Creator
Creator

Days between

 
Labels (1)
4 Replies
Claudiu_Anghelescu
Specialist
Specialist

=Date2 - Date1

 

But Date2 should to have the same format as Date1

So Date#(Date2,'DD/MM/YYYY') as Date2

To help community find solutions, please don't forget to mark as correct.
soha1902
Creator
Creator
Author

 

 

Claudiu_Anghelescu
Specialist
Specialist

Check this:

To help community find solutions, please don't forget to mark as correct.
pradosh_thakur
Master II
Master II

Use interval() function

 

Interval(date1-date2,'DD')

Learning never stops.