Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On May 18th at 10AM EDT we will answer your QlikView questions live. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
dunnalahk123
Creator III
Creator III

Calc to last 45 days from today

Hi,

 

Can some one help here , i am trying to create  a flag in load script  for one date field

 

 the date should give me always last 45 days from today  

 

Normally to get 60 days from today i wrote below by using ADD months  and it works , same how can we write for 45 days.


IF( Date(Floor( [Last True Billable SubTask Actual End date]),'MM/DD/YYYY') > AddMonths(Today(), -2) , 1, 0)

Labels (1)
1 Solution

Accepted Solutions
dunnalahk123
Creator III
Creator III
Author

HI,

 

Thank You . it works. 

View solution in original post

3 Replies
santhiqlik
Creator
Creator

Hi,
Try this..


IF( Date(Floor( [Last True Billable SubTask Actual End date]),'MM/DD/YYYY') > (Today()-45) , 1, 0)
dunnalahk123
Creator III
Creator III
Author

HI,

 

Thank You . it works. 

View solution in original post

dunnalahk123
Creator III
Creator III
Author

Hi,

Sorry.

Its not working as expected , bec i can see dates greater than today date as per below snapshot