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
- All Categories
- 1.2K Product Ideas
- 1.2K Ideas Exchange
- 1.3K Connect
- 1K Connectors
- 267 Workbench
- Cloud Amplifier
- 3 Federated
- 2.5K Transform
- 78 SQL DataFlows
- 524 Datasets
- 1.9K Magic ETL
- 2.9K Visualize
- 2.2K Charting
- 433 Beast Mode
- 22 Variables
- 508 Automate
- 114 Apps
- 386 APIs & Domo Developer
- 8 Workflows
- 26 Predict
- 10 Jupyter Workspaces
- 16 R & Python Tiles
- 331 Distribute
- 76 Domo Everywhere
- 255 Scheduled Reports
- 65 Manage
- 65 Governance & Security
- 1 Product Release Questions
- Community Forums
- 40 Getting Started
- 26 Community Member Introductions
- 67 Community Announcements
- 4.8K Archive