Skip to main content
Announcements
Qlik Connect 2025: 3 days of full immersion in data, analytics, and AI. May 13-15 | Orlando, FL: Learn More
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 (3)
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)