Hello:
I am trying to create a report that is scheduled to run automatically once a week on Thursday mornings and returns the records that were added from the past week only. So, if it were run tomorrow, the desired date range would be January 23, 2014 12:00 AM - January 29, 2014 11:59 PM This date range also needs to be displayed as text in the report.
I'm having a hard time in writing the filter (I'm assuming this requires a filter) and I can't seem to find good documentation, so I'm almost shooting in the dark. I would appreciate any help you can give.
Thank you,
cogb
Hi,
How about
[Your created date item] between current_date and _add_days(current_date,-7)
Cheers!
MF.