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

SSO Admin Screen - Remove the ‘Load from XML file’ option given that its not reliable
We have had issues updating our SSO cert and have been advised by support not to use the above option. Given that it is not reliable, it would be better to have it removed so that users are forced to use the manual option which works consistently.
Drill to Transaction Functionality in the New UX
Bringing this up again as the previous post from "5 years ago" is gettling lost. We need drill to transaction on the New UX, it is stopping us transitioning to the New UX Dashboards, as we use it daily, even hourly in our Supply chain function. Are there any plans to add Drill to Transaction to the new UX Please?
Drop Down Menu for NUX
In as much detail as possible, describe the problem or experience related to your idea. Please provide the context of what you were trying to do and include specific examples or workarounds: A dropdown menu / fold option as a UX element would be extremely beneficial for users who want to extract important information or…