Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
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. 

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