Dataset Date Range - End Date = Today

AbsentCurtis

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.

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.