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

Announcements
ALERT: QlikView server communication interruptions following Microsoft Windows Domain Controller security updates
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Expression for Calculating 1st occurrence date

Hi All,

what is expression for calculating no of days between 2 dates.

I have 2 date fields 'start date ','end date' , i need to calculate the 1 occurred date of 'start date ' and last occurred date of 'end date' .

Thank you all

Labels (1)
10 Replies
ecolomer
Master II
Master II

Try this:


=floor(End_Date)- floor(Start_Date) as [delay in no of days]