SELECT NOW() Query Chain

Need to add a timestamp to your data pulls? Make it easy with this connected query that serves as a work around for the TODAY() formula that can be manually refreshed or scheduled using a chain in the Workiva data platform.
Template Contents
Add to Workspace

Don't have an account? Contact us to get started.

Add context to your data by automatically pulling the current date.

When importing new data into a spreadsheet or report, now you can always know the exact day it happened. This template includes a query that will select the current date. You can schedule it to run each day and send it to a spreadsheet, or connect the query to a spreadsheet that you can update as needed with the push of a button. Perfect for scheduled or ad hoc reporting—any time you need stakeholders to know precisely how current your numbers and narrative are.


Key Features
  • Pre-built query built for the Workiva data platform
  • Instructions on how to make a chain to update a spreadsheet
Compatible Solutions
To use this item, your organization needs to have purchased one of the following solutions.
CFO Deck
Flash & KPI Reporting
Management Reporting (CFO)
To use this item, your organization needs to have purchased Wdata.

Frequently Asked Questions

The template includes instructions and tips on how to build your process or incorporate the functionality into an existing one.
Fit for Purpose Solutions
CFO Deck Connect financial, operational, and other enterprisewide data directly from your many sources to documents, spreadsheets, and presentations. CFO Deck
Flash & KPI Reporting Connect data directly to your flash reports and link that information to all other reports and analysis down the line. Flash & KPI Reporting
Management Reporting Mitigate risk by connecting data at the source to create an ecosystem of reliable, actionable reports, statements, and presentations. Management Reporting (CFO)