Hi, I would like to calculate the QTD and HTD in a module. It is noticed that the QUARTERTODATE() and HALFYEARTODATE() function are not working when the Quarter Totals and Half Year Totals been disabled in the time setting. An error message is prompted when the formula is saved. After the Quarter Totals and Half Year Totals are enabled, the formula using these functions are saved without issue. I think the function should work regardless of the time setting. However, it looks like the time setting is the pre-requisite for the functions and it didn't mention in the Anapedia. Could anyone confirm it? Thanks.
... View more
