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 Crome you can download Extension Valantic which helps you to:- Show Actions & File IDs:- View internal IDs for Processes, Imports, and Files to help with API integrations. Show Action Usages:- Identify where your Actions are used across Apps and Pages. Show Linked Pages:-See which Apps and Pages use your modules to…
Currently when a user triggers a workflow action it does not provide a window pop up like we have in actions when its ran successfully. Can there be window pop up after triggering the workflow from UX which can do 2 things as below. pops up a message to user that workflow is successfully triggered refreshes the page…
Hi, our users have successfully tested the required functionalities in the UAT environment, and we are now planning to roll out a new Production environment for them. Could you please guide us on the necessary steps and prerequisites for setting up the new Production environment? Thanks in Advance
