Amazon QuickSight – Now
The ‘now’ function in Amazon QuickSight returns the current date and time, based on the time zone set in the QuickSight account.
Syntax
#Start# now() #End#
This function does not require any parameters.
Suppose you want to create a report that shows the current date and time when the report is viewed. You can use the now function to accomplish this.
Assume that you have a simple report with one text box where you want to display the current date and time. To add the current date and time to the report, follow these steps:
- Select the text box where you want to display the current date and time.
- In the data pane on the right-hand side, click on the “Functions” tab.
- Scroll down to the “DateTime” section and click on the “now” function.
- The function will be inserted into the text box, and the current date and time will be displayed.
Example
#Start# now() #End#
The text box will now display the current date and time in the format “MM/DD/YYYY HH:MM:SS”, based on the time zone set in your QuickSight account. This value will be updated every time the report is refreshed or viewed, so it will always show the current date and time.