Hi there,

i would like to give to a static parameter a default value from a function.

Specifically, i need to create a parameter, which by default contains the current date, so the user can *edit* the datetime, to for example, remove the time (leaving the date).
Is that possible?
I would like to express the default parameter value in a formula, like {!current_date}?

I've tried an alternative solution by creating a dynamic parameter from the query "select toString(datetime()) from table limit 1", which returns the current date as i want, but when launching the report, is not possible edit it...

some ideas?

thanks!

 

If it is a date, why not just the 'today' value.  If the only thing that the user is editing is the time, is your report time sensitive for the date, or do you just want all the values of a particular date?

 

you could make the parameter nullable and if null use the current datetime value or date, whichever is desired.

 

again, I'm just confused as it seems that you are doing a lot of work for what seems like a simple parameter...though it seems that I miss the obvious sometimes.