Get Last Day of Month from Date Field - Triggered Actions

[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?

[DrSimi]

Hi kpcollier,

 

Try this:

 

LastDayofMonth will be equal to 30 for the date in the screenshot (June 7th 2023), but if you change it to, say, February 20th 2023, LastDayofMonth will be 28.

P.S. TBH I'm not sure  if all variables are required, I just tested until it worked  

[Tubby]

Welp. I guess I didn't have to use a variable to hold the value:

Made it even shorter I guess hahaha

[kpcollier]

@DrSimi This is neat. Looks like you're using the system's date math operations in a loop. Once the date gets to the end of the month, the CheckMonth variable would switch to the next month, and that's when you know when you've reached the end of the month. Simply subtract a day from that and there's my answer.

Many thanks for this!

[Tubby]

Got an idea after seeing @DrSimi's answer. I was able to make the query shorter in triggered action:

I'll try my best to explain how it worked.

It subtracts 1  day short from the original day value to get the first day of the month in the variable. So you can actually name the variable "first day of the month". 
Then, in the update, I simply added 1 month to the variable to get the first day of the next month and lastly, subtracted 1 day to the output date so it gets the day before it which is always the last day of the previous month (which is the month of your original input).

I really hope I am making sense but anyways it worked for month's with 28,30, and 31 as the last day. Cheers!

[kpcollier]

@Tubby This is great! Much appreciated!