• FEATURES
  • PRICING
  • MARKETPLACE
  • CASE STUDIES
  • BLOG
  • Create job with parameters

    We have a query with parameterized filter between two dates.

    We are looking to schedule this as a monthly job. Is there a way to schedule this to run automatically filling in the begin/end dates as the begin/end date of the previous month?

    Hi Prayuja,

    Thanks, I’ll look into the temporal functions.

    For now I tracked down the SQL used for the query and used it in a PHP script.

    Hi Prayuja,

    Temporal function worked great for my needs.

    Thanks again,
    John

    1 Like