topic Problem with setting date variables using a button in QlikView

Problem with setting date variables using a button

Wed, 05 Oct 2011 14:26:52 GMT

Hi All,

I'm trying to use a button to set some date variables which are displayed in two calendar controls.

Unfortunately I either get:

1) The date (e.g. today()) being displayed in the calendar controls but the variable value

being set to 30/12/1899

2) No dates are displayed in the calendar controls but the variables are correctly set by the button actions.

Please can you take a look at the attached example qvw

Many Thanks for your help.

Dave.

Problem with setting date variables using a button

Wed, 05 Oct 2011 14:31:50 GMT

add quotes around the variable to display correctly '$(vDatefrom)' displays 05/10/2011 without it seems to be seeing it as a divison

Problem with setting date variables using a button

Wed, 05 Oct 2011 15:01:18 GMT

Thanks, its worked. Strange how it interprets the dates without the quotes.

Problem with setting date variables using a button

Wed, 05 Oct 2011 15:03:53 GMT

That was because originally it was doing 5 divided by 10 devided by 2011, then formatting the result as a date. the quotes tell it that it is a text string and not a formula