topic Re: Problem with Dates in QlikView

Problem with Dates

Wed, 24 Jul 2013 15:24:26 GMT

Hi everybody,

I have this problem. I have dates on SQL like this: 2008-06-30 10:10:00

If i create a master calendar using Week, Day, Month, everything is OK.

The problem is that i want now the date WITHOUT hour, minute and seconds but ALSO working the calendar

(because if i convert dates in SQL, then it doesn't work on QV the calendar)

Any help?

Thanks!

Re: Problem with Dates

Gysbert_Wassenaar — Wed, 24 Jul 2013 15:32:22 GMT

You can use the floor function to cut off the time part of a datetime/timestamp value: floor(MyDate) as DateWithoutTime. See this blog post for more information: The Master Time Table

Re: Problem with Dates

Anonymous — Wed, 24 Jul 2013 15:37:49 GMT

I use the function Date (MyDate) for dates without hour, minute and seconds.

Re: Problem with Dates

Wed, 24 Jul 2013 15:47:49 GMT

Yeah, thats works fine,

Thanks all