I need to calculate a week ending being Saturday. I computed the week ending day with this formula -
DATE(String(Year(SOARDUEDATE), "9999") + "/" + String(Month(SOARDUEDATE), "99") + '/' +
String(Day(SOARDUEDATE + (7 - Weekday(SOARDUEDATE))), '99'))
However, it is having problems with dates such as 6/1 - which has a week ending date of 6/4 - my formula does not change the month - and a date of 6/1 has a week ending of 5/1.
Let Progress do the month (and year) overflow stuff:
MESSAGE SOARDUEDATE + (7 - WEEKDAY (SOARDUEDATE))
VIEW-AS ALERT-BOX INFO BUTTONS OK.
Thank you!!! Worked great.