Dataset Date Range - End Date = Today
AbsentCurtis
Member
in Archive
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.4K Product Ideas
- 1.4K Ideas Exchange
- 1.4K Connect
- 1.1K Connectors
- 282 Workbench
- 3 Cloud Amplifier
- 4 Federated
- 2.8K Transform
- 86 SQL DataFlows
- 548 Datasets
- 2.2K Magic ETL
- 3.2K Visualize
- 2.3K Charting
- 544 Beast Mode
- App Studio
- 26 Variables
- 566 Automate
- 134 Apps
- 411 APIs & Domo Developer
- 21 Workflows
- DomoAI
- 28 Predict
- 12 Jupyter Workspaces
- 16 R & Python Tiles
- 345 Distribute
- 87 Domo Everywhere
- 257 Scheduled Reports
- 1 Software Integrations
- 85 Manage
- 84 Governance & Security
- 6 Product Release Questions
- Community Forums
- 41 Getting Started
- 27 Community Member Introductions
- 81 Community Announcements
- 4.8K Archive