Discussion Board for collaboration on QlikView Scripting.
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)
Thank You . it works.
View solution in original post