Should I hard code in future years?
Q1 = January 1 - March 31
Q2 = April 1 - June 30
Q3 = July 1 - September 30
Q4 = October 1 - December 31
18 réponses
Forum Ambassador Eric Praud (Activ8 Solar Energies)
Hi,
This is going to the "else" result, so I woudl assume your picklist values are not Q1, Q2, Q3 or Q4.
Can you take a screenshot of the picklist values in the set up area like so:
Also, for the End Date, the formula won't work, use the one with ADDMONTHS
It's working fine for me