topic Date Formatting in QlikView

Date Formatting

Wed, 14 Jul 2010 14:13:50 GMT

We have a date field (ex. 7/9/2010 14:36) which QV doen't see as a date. What function do we use for QV to read it as a date and also we need to separate it into three different fields as a Year, Month, Date.

Thank you

Date Formatting

Wed, 14 Jul 2010 14:25:59 GMT

Hi,

use

Date(Timestamp#('DD/MM/YYYY hh:mm')) as MyDate

and time functions like Year(MyDate) as Year and so on.

See QV help for more details.

Good luck!

Rainer

Date Formatting

Wed, 14 Jul 2010 14:35:39 GMT

Hi Rainer,

Thanks for a quick reply, but that did not work. Any other suggestions?

Polina

Date Formatting

syed_muzammil — Wed, 14 Jul 2010 14:37:08 GMT

Hi,

You can use the date( expression [ , format-code ] ) .

Where format code is the format u want the date to be in.

Date Formatting

Wed, 14 Jul 2010 14:39:29 GMT

We used this expression

Date(Timestamp#([Last Updated],'DD/MM/YYYY hh:mm')) and it worked.

Thanks for your help.

Date Formatting

johnw — Thu, 15 Jul 2010 00:47:07 GMT

I recommend:

date(floor(timestamp#([Last Updated],'DD/MM/YYYY hh:mm')))

Without the floor() function, it is only DISPLAYING as a Date, but there is still a time associated with it. So you can get multiple "dates" that all look the same.