Scripting Question

ASK To set automatic date weekly report

08/04/2015 1171 views
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.

Answer Summary:
0 Comments   [ + ] Show comments


Answer Chosen by the Author

Use CREATED > DATE_SUB(NOW(), INTERVAL 7 DAY) instead of hard coding the dates. Then schedule the report to run every Wednesday.

Answered 08/04/2015 by: chucksteel
Red Belt

  • Thanks checuksteel, it's very helpfully
This website uses cookies. By continuing to use this site and/or clicking the "Accept" button you are providing consent Quest Software and its affiliates do NOT sell the Personal Data you provide to us either when you register on our websites or when you do business with us. For more information about our Privacy Policy and our data protection efforts, please visit GDPR-HQ