Change Date to Last day of Prev Month

[jenner85]

Hello there! 
I am trying to do the following, help is appreciated. Thank you! 

Date	Period
8/5/2020	7/31/2020
9/2/2020	8/31/2020

[jenner85 · Accepted solution]

Well, I actually answered my own question and used these 2 formulas:

DateTimeAdd([Date],-1,"month")

DateTimeTrim([Date],"lastofmonth")

[TheOC · Accepted solution]

hi @jenner85 

I acheived this with the following workflow:

Please find it attached!

[TheOC]

@jenner85  beat me to it!

Glad you got sorted 🙂