I have a formula that gives me the date range for each week. Weeks are considered as Monday through Sunday. What I am trying to fix is when I run a report for LAST MONTH (November), the first week date range will begin on 10/28 to 11/03, which is Monday to Sunday. I am trying to get it to show 11/01 to 11/03.
Here is my current formula:
local datetimevar start;
local datetimevar end;
totext(start,"MM/dd") & chr(10)&"to" & chr(10)& totext(end, "MM/dd")