I have a date field, Order_Date, in my table. In my Update Triggered Action, I need to get the last day of the month from this Order_Date value. I'll then need to use this value in an IF/THEN block.
In example, if Order_Date = 05/22/2023, then the variable value would output 05/31/2023. If Order_Date = 06/07/2023, the variable would output 06/30/2023.
You can post now and register later.
If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.
Question
kpcollier
I have a date field, Order_Date, in my table. In my Update Triggered Action, I need to get the last day of the month from this Order_Date value. I'll then need to use this value in an IF/THEN block.
In example, if Order_Date = 05/22/2023, then the variable value would output 05/31/2023. If Order_Date = 06/07/2023, the variable would output 06/30/2023.
Any ideas how to do this in triggered actions?
Link to comment
Share on other sites
5 answers to this question
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.