I have a data field and I would like to establish a date 26 work weeks prior to that. Not too sure if there is a week function that does this. Effectively, the formula will look like this if I were to use MS access:
If([DevCode] = "N" or [DevCode] = "RN", Dateadd["w", 26, Approved Completion Date], dateadd(["W", 25", Dept Signage Ordered])
Need to clear my concept on such calculations in QB.
This calculation would give the same day of the week as the original date. So a Monday would become the Monday 26 weeks ago, and a Saturday would be 26th Saturday in the past.
If you wanted to move the result to the Monday, then you could do this
WeekDayAdd([My date field]- Weeks(26)),0)
I have not tested that last part but t should work.
If([DevCode] = "N" or [DevCode] = "RN", [Approved Completion Date]-Weeks(26), [Approved Completion Date]-Weeks(18))
If I remove the if condition I get the right result but I do have to use the if condition. Am I making some mistake here? Formula is otherwise acceptable to QB.