Hello everyone,
I was wondering if there was a button I could make that would set my field [Day # in FQ] to the current day based on the date, for all my quarters. For example, I have three quarters being compared Q2 FY11, Q1 FY12, and Q2 FY12. My excel data only goes up to day 46 in Q2 FY12 because this is the day we are currently on in the qtr, however the other two quarters go all the way to day 90. I need help writing the expression that would allow all the three quarters to be on the same day based on the last day in the current quarter (Q2FY12). I would assume if I can write the expression than I could simply bookmart it and turn it into a button? Or if there's another way to go about doing this any help would be greatly appreciated.
Thanks for all the help and let me know if you have any questions/need any more information,
Alex
