Selection Formula, Need to get Date after a week ago Sunday.

Post Author: DaveChel

CA Forum: Formula

I need to create a selection formula which selects tasks that are not completed or were completed last week. So far I have:

isnull({TASKS.COMPLETED}) or

dateadd("d", 7,{TASKS.COMPLETED}) in weektodatefromsun

But I don't think that will work. In other words, no matter which day this week the report is run I want to pull Tasks.Completed (a date/time field) for values from the previous week Sunday to Monday.

I've been working on this myself for some time. Looked in the help section and searched this and another message board. Can anyone point me in the right direction?