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
Queries
Wdata
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
Prerequisites
To use this item, your organization needs to have purchased Wdata.
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.
Flash & KPI Reporting
Connect data directly to your flash reports and link that information to all other reports and analysis down the line.
Management Reporting
Mitigate risk by connecting data at the source to create an ecosystem of reliable, actionable reports, statements, and presentations.