Dataset Date Range - End Date = Today
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.
0
Comments
-
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'0
This discussion has been closed.
Categories
- 10.5K All Categories
- 3 Connect
- 913 Connectors
- 250 Workbench
- 458 Transform
- 1.7K Magic ETL
- 69 SQL DataFlows
- 476 Datasets
- 182 Visualize
- 249 Beast Mode
- 2.1K Charting
- 11 Variables
- 16 Automate
- 354 APIs & Domo Developer
- 88 Apps
- 3 Workflows
- 20 Predict
- 5 Jupyter Workspaces
- 15 R & Python Tiles
- 245 Distribute
- 62 Domo Everywhere
- 242 Scheduled Reports
- 20 Manage
- 41 Governance & Security
- 168 Product Ideas
- 1.2K Ideas Exchange
- 9 Community Forums
- 27 Getting Started
- 14 Community Member Introductions
- 55 Community News
- 4.5K Archive