Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi community,
How would I make a variable that would be the the date of this years Feb 1st until next years Feb 1st has passed? This variable will change to next years Feb 1st, 2/1/2013, on that day.
How about:
LET vX = YearStart(today(), 0, 2)
-Rob
=if(today()>date('2/1/'&year(today()), 'M/D/YYYY'), date('2/1/'&year(today()), 'M/D/YYYY'), date('2/1/'&(year(today())-1), 'M/D/YYYY'))
I figured it out looking at QV Help, but this is correct.