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 |
Solved! Go to Solution.
Well, I actually answered my own question and used these 2 formulas:
DateTimeAdd([Date],-1,"month")
DateTimeTrim([Date],"lastofmonth")
@jenner85 beat me to it!
Glad you got sorted 🙂