Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

Conversion of datetime to date

Hi -

What is the generel rule by convert a datetime to a date?

Eg in SQL cast('2014-01-15 03:00:00.00' as date) equals 2014-01-15 and then it spands from 2014-01-15 00:00:00.001 to 2014-01-15 23:59:59.999

But when i do this in Qlikview Date#(Date(CreateDate, 'YYYY-MM-DD') - then i dont get all my data (some of my data from the 15th is pushed back to the 14th.

How can i avoid this?

Tags (3)
2 Replies

Re: Conversion of datetime to date

Wrap your date field in floor():

=date(floor(YourDateField))

This will get rid of the timestamp.

Not applicable

Re: Conversion of datetime to date

I already have my timestamp off - But i just misunderstood my own data. So its okay

Community Browser