ASK To set automatic date weekly report
Dear All,
Need your help, until now we have a problem about setting report scheduling. because in my company want to report Helpdesk weekly Wednesday to Wednesday.
every week we must set like this :
we need automatically set reporting Helpdesk weekly scheduling Wednesday to Wednesday.
Thanks
0 Comments
[ + ] Show comments
Answers (1)
Answer Summary:
Please log in to answer
Posted by:
chucksteel
8 years ago
Top Answer
Use CREATED > DATE_SUB(NOW(), INTERVAL 7 DAY) instead of hard coding the dates. Then schedule the report to run every Wednesday.
Comments:
-
Thanks checuksteel, it's very helpfully - bocah90 8 years ago
