ENDOFQUARTER formula

For modules building, it would be helpful to have a ENDOFQUARTER formula to identify the end of quarter date of a date.

Comments

You could do 3 line items (Date, Period, End Date)
line item—-Format—————————Formula.
Date.———-Date. —————————-Start() ← Should already be in the model
Period ——-Time Period (quarter)—- period(Date.) ← Would probably already be in the model
End Date —-Date —————————-"end(period)"
but I agree it would be quicker with one command

Dikshant

@MarionCarrie,

ENDOFQUARTER(Date) =
IF MONTH(Date) <= 3 THEN DATE(YEAR(Date), 3, 31)
ELSEIF MONTH(Date) <= 6 THEN DATE(YEAR(Date), 6, 30)
ELSEIF MONTH(Date) <= 9 THEN DATE(YEAR(Date), 9, 30)
ELSE DATE(YEAR(Date), 12, 31)

This formula checks the month of the given date and returns the end of the corresponding quarter.

MarionCarrie

THANK YOU SO MUCH !

Quick Links

New ideas

Full Refresh with option to do a structural refresh
Currently a full refresh only refreshes the data. Structural changes should also be able to be fully refreshed into an existing source data object.
Trash Bin in ADO
In case an object is deleted by error, it should be retrievable back from a trash bin.
FCR: Request to enhance the audit functionality
Backgrounds We have a question regarding Logs > Session Log. Currently, system activity logs are only available for a limited number of functions, such as Journal operations and metadata updates. As a result, some system administrators on the customer side have found the current audit capabilities insufficient and have…