Dataset Date Range - End Date = Today

AbsentCurtis
AbsentCurtis
in Workbench

Is it possible to set the end date of a dataset date range as a dynamic entry where it always equals the day that the task is run?  It seems a bit of a pain to have to manually adjust end dates periodically.

Comments

  • PodiumMason
    PodiumMason 🟢

    Hey Curtis!

     

    Are you querying a database in workbench to get data into Domo? If this is the case, you could do a "where" statement in your query that pulls dates between whatever beginning date you want and the current date. That way the data would always be pulled as of the current date the job is run.

     

    so it might look something like Where `Date` Between '2017-01-01' and Current_date()

     

    Let me know if this is helpful or if this is a different issue altogether. 

     

     

    **Say 'Thanks' by clicking the thumbs up in the post that helped you.
    **Please mark the post that solves your problem as 'Accepted Solution'
This discussion has been closed.

Categories