There must be a valid expression inside parentheses.
AdjustMonth([Grease Location Opening Date],(ToNumber([FREQUENCY])/4),( Date d)Firstdayofweek))
The "Grease Location Opening Date" will be manually entered. I would like the "Week of First Collection" field to auto-populate by taking the opening date & adding the frequency (in weeks) to get to date of the first collection. Then I would like that field to show the date for the first day of the week. So, the "week of first collection" date will always be a Sunday.
The "Grease Location Opening Date" will be manually entered. I would like the "Week of First Collection" field to auto-populate by taking the opening date & adding the frequency (in weeks) to get to date of the first collection. Then I would like that field to show the date for the first day of the week. So, the "week of first collection" date will always be a Sunday.
------------------------------
Laura Diak
------------------------------
