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: 
inam
Contributor III
Contributor III

start date minus end date

Hello Community ,

i want start date minus end date. i have table like 

date
16-Apr-2023
17-Apr-2023
18-Apr-2023
19-Apr-2023
20-Apr-2023
21-Apr-2023
22-Apr-2023
23-Apr-2023
24-Apr-2023
25-Apr-2023
26-Apr-2023

 

here 16 is startdate & 26 is enddate 

expected output:

finaldate
-10

 

 

Labels (4)
1 Reply
Kushal_Chawda

@inam If your date is in proper date format you can try below

=min(Date)-max(Date)

or 

min(total Date)-max(total Date)