Calc to last 45 days from today

[dunnalahk123]

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)

[santhiqlik]

Hi,
Try this..


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

[dunnalahk123 · Accepted solution]

HI,

Thank You . it works. 

[dunnalahk123]

Hi,

Sorry.

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