I am building a workflow where I need to add/remove x-number of days to either the beginning or end of current, previous and next month. I have this part nailed down and working as expected. The date calculations are based on 3 initial values using these calculations:
CurrentMonth = (expecting May)
PreviousMonth = Expecting April --> Actual is March
This all worked as expected a few days ago, but now when I test on 1st May. The value for PreviousMonth is returning March 31st. My best guess is that by subtracting 1 Month, it is actually subtracting 31 days?
I could work around this by subtracting 4-weeks rather than 1-month but I'd like to know if I am missing anything here or if someone has seen a similar issue?