opportunity/activity report
I'm trying to create a report showing any activity that is due within the next week, from my opportunity pipeline.
I am basing it off the Planned Start Time field for the Activity and included this filter in my report but it doesn't seem to work
FILTER("- Date Planned Start"."Planned Start Time" USING "- Date Planned Start"."Planned Start Time" >= CURRENT_DATE AND "- Date Planned Start"."Planned Start Time" <= CURRENT_DATE + 5)
Any suggestions would be welcom?
Thanks,
Jo-Ann