topic Re: Pass Date parameters in URL in QlikView

Pass Date parameters in URL

Mon, 07 Dec 2015 14:24:57 GMT

I know there are several threads on here related to passing URL parameters, but I am having issues trying to pass a date value. The format I am trying is something like this...

https://...&select=LB-FARegionHidden,APJ&select=SL-FACalDate,11%2F25%2F2015

However, the date parameter does not seem to get applied. I've tried some other date formats like '&select=SL-FACalDate,2015-11-15'

but nothing seems to work.

Re: Pass Date parameters in URL

Gysbert_Wassenaar — Mon, 07 Dec 2015 18:38:49 GMT

Not sure this works, but you could try this: &select=SL-FACalDate,("2015-11-15")

Or perhaps you need to use the numeric value: &select=SL-FACalDate,42323

Re: Pass Date parameters in URL

miriam — Fri, 17 Jan 2020 13:44:47 GMT

The numeric value wasn't working for me.

I am using the german version:
&lang=de-DE

It worked with:
&select=SL-FACalDate,"01.12.2019%2000:00:00"

or for multiple values:
&select=SL-FACalDate,("10.12.2019%2000:00:00"|"11.12.2019%2000:00:00")