For modules building, it would be helpful to have a ENDOFQUARTER formula to identify the end of quarter date of a date.
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
@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.
THANK YOU SO MUCH !
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: Applying things like bps is great but would be great to not have the space between number and item. For pre-defined ones such as %…
Currently Templates can only be run on a certain day of the week or selected date of the month. It would be great if it can have more options to trigger workflows
Before we start, here's a quick description of what are simple lists. Then, I will share how each level in a simple list can be flagged. Simple lists contain list items in a single list with a parent/child hierarchy. For example: It's often tricky to apply logics to this list because you can only add data to child list…
