Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
How to define variable like below.
Format required: YYYYMMDD
vsomething= today minus 40 days. so in this case vSomething=20150215 (40 days from today)
caviat: condition where year has to be current year. In this case if this variable got executed on january 20 (where 40 days minus falls into 2014), it will default the start date to 20150101
Thanks for the help in advance.
= date( if( Today()-40 < YearStart(Today()) , YearStart(Today()) , date(Today()-40) ) , 'YYYYMMDD')
vPast40Days = Date(Today() - 40, 'YYYYMMDD');
= date( if( Today()-40 < YearStart(Today()) , YearStart(Today()) , date(Today()-40) ) , 'YYYYMMDD')