Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi ,
I have a calendar object , wherein , I have hard-coded:
min value as Num(Date#('01/01/2016', 'MM/DD/YYYY'))
max value as Num(today())
How can i make min value dynamic to always be 01/01/current year-1 , so in 2018 , it should be 01/01/2017
There is another requirement to have min value as : Num(Date#('01/01/2016', 'MM/DD/YYYY'))
max value as 12/31/current-year-2, so in 2018 , max value will be 12/31/2016
How can max value be made dynamic?
Min date for previous year
=YearStart(Addyears(today(),-1))
Max date for previous year
=YearEnd(Addyears(today(),-1))