RickBooker
Technical User
I have the following formula that computes data that is 7 weeks in the future:
if {JOB_START_DATE}-42 in WeekToDateFromSun
then {QTY_TO_MAKE}-{QTY_MANUFACTURED}
What I am trying to do is create a formula that will collect all data beyond 7 weeks. The number of weeks have to be from Sunday not current date.
Is there a way to compute the date of the first day of the week (sunday) that a date falls in? ie. if the date falls on thursday that is 8 weeks in the future can I compute the first day of that week?
Any point in the right direction would be appreciated.
Rick
if {JOB_START_DATE}-42 in WeekToDateFromSun
then {QTY_TO_MAKE}-{QTY_MANUFACTURED}
What I am trying to do is create a formula that will collect all data beyond 7 weeks. The number of weeks have to be from Sunday not current date.
Is there a way to compute the date of the first day of the week (sunday) that a date falls in? ie. if the date falls on thursday that is 8 weeks in the future can I compute the first day of that week?
Any point in the right direction would be appreciated.
Rick