TODAY() function returns NULL and couldn't be assigned to parameter.

Published: 17 Aug 2023
Last Modified Date: 18 Aug 2023


When trying to assign today's date to the parameter by using the calculated field has TODAY() function to "Value when workbook opens" of "Create Parameter", "value is null and couldn't be assigned to this parameter." error appeared.
User-added image
The calculation is valid, but for some reason, it returns null.
User-added image


  • Tableau Desktop
  • Tableau Cloud
  • Tableau Server


Option 1

Make sure the data source have one or more records.

Option 2

Use Dashboard Extension: Date Updater


If the data source has no records, the calculation field of TODAY() function cannot return a value and will be NULL.
Did this article resolve the issue?