By using this website, you agree to our Terms of Use (click here)
Hi everyone, I have a monthly income statement where the column headers need to be in the MM/dd/yyyy format. I'm currently using the below formula, which works but if my start period date ends in 28 or 30, my months that end with 31 show the 28 or 30 instead.
This formula shows the 2 months prior to my start period selected when running the report =Format( '{0: MM/dd/yyyy}', DateAdd( Report.GetPeriodEndDate(@StartPeriod), 'm', -2))
When running for StartPeriod 03-2021, my report shows the dates properly. See below.
However, if I run it for StartPeriod 04-2021, my report shows the dates using the PeriodEndDate for April (30 instead of 31). See below.
The below example is running for 02-2021.
Any and all help is greatly appreciated!
This looks kind of familiar. I think I've run into something similar. I know it's clunky and winds up with a larger formula, but what about adding a day, then going back a month, then subtracting a day?