I need to schedule a report to all the first days of months, but for that I need that one specific date (Report Date) just give me the falues from last month.
So probably I need to create one formulas for the last day of the previous month, because the first day of previous month it's already created in like an Techinal Object in DataBase, but for some reason they don't create the last day of previous month.
Or maybe I just need to create one formula the give me the day of last month, but I already tried and didn't work.
=RelativeDate(Max([Report Date]);-DayNumberOfMonth([Report Date]))+1)
I already search but I didn't find a solution.
Hope you can help me.
Thanks in advance.