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.
The calculation is valid, but for some reason, it returns null.
Make sure the data source have one or more records.