Skip to main content
Question

Assign the TODAY() Function as a value to a variable

  • September 2, 2022
  • 1 reply
  • 57 views

Forum|alt.badge.img+6

Hi everyone,

 

I have an Analysis where i can filter on specific time periods. I added several Variable Inputs where the user can type in dates and times (Start date and end date + start time and end time, e.g. '2022-07-10', '2022-08-10', '15' ..). (See Screenshot for details)

 

Whatever the user types into the Variable input field is then assigned to a Variable. Now I also added a Button who should set the variables to a predefined value (like a reset button for the filter). As the end date I would like to use the todays date but unfortunately the TODAY() Function cannot be added as a value for a variable.

 

Do you have any ideas to solve this problem?

 

Best, Niklas

1 reply

Yes you can assign today()

 

image 

Maybe the problem is that, if you define the variable as STATIC... then you get this:

 

image 

I guess that try-and-error a bit with Today and formatting will fix your problems

 

HTH