Problem with Dates

[#1]

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!

[Gysbert_Wassenaar]

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

[Anonymous · Accepted solution]

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

[#4]

Yeah, thats works fine,

Thanks all