topic Re: Date question in QlikView

Date question

userid128223 — Thu, 12 Jan 2017 21:11:00 GMT

I have following 2 variable and i cannot seem to pass variable to weekstart function it gives incorrect results.

LET vToday = today();

Let WeekStart = date(WeekStart($(vToday),0,6));

Results:

vToday=1/12/2017

WeekStart=12/24/1899

Re: Date question

vishsaggi — Thu, 12 Jan 2017 21:15:48 GMT

Try this ?

Let vWeekStart = date(WeekStart('$(vToday)',0,6));

Re: Date question

userid128223 — Thu, 12 Jan 2017 21:27:08 GMT

putting quotes around vToday varibale worked

'$(vToday)'

Can you please explain the logic why single quote is required.

Re: Date question

vishsaggi — Thu, 12 Jan 2017 21:39:32 GMT

To my understanding the Datetime stores as a string value, so if we are using a variable value inside an expression or a function use I usually use single quotes. Thats the reason i believe we get some random dates. For eg: You can try below in a text object:

= Date('2015-10-12', 'YYYY-MM-DD') -> With Quotes

= Date(2015-10-12, 'YYYY-MM-DD') -> Without Quotes.

Re: Date question

userid128223 — Thu, 12 Jan 2017 22:14:03 GMT

Thank You.