Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
How can I find out if a month is in between a unfinished quarter or not in the front end.
Say for example I have Months:
Jan 2015
Feb 2015
Mar 2015
Apr 2015
May 2015
Jun 2015
Jul 2015
Aug 2015
Sep 2015
Oct 2015
Nov 2015
Dec 2015
Jan 2016
Feb 2016
Mar 2016
I have to write a different expression for Jan 2016, Feb 2016 and Mar 2016 since those months are still in between a unfinished quarter.
Whereas for the other months, the quarter has already finished.
Say for example when we are in the month of Apr 2016, I'll have one expression for all the months and a different one for Apr 2016 since it's still in between a unfinished quarter.
Hope I made myself clear.
Thanks for all the help.
Regards,
Roy
Something like this?
=InQuarterToDate(Months, Today(), 0)