variables

[#1]

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.

[jpenuliar]

vPast40Days = Date(Today() - 40, 'YYYYMMDD');

[luciancotea · Accepted solution]

= date( if( Today()-40 < YearStart(Today()) , YearStart(Today()) , date(Today()-40) ) , 'YYYYMMDD')