topic Cannot display date in dd/mm/yy format. in QlikView

Cannot display date in dd/mm/yy format.

Mon, 23 Jan 2012 12:56:03 GMT

Hello all.

I have a date field (called EnterDatetime) which currently shows dates in the following format: dd/mm/yyyy

To save space, I need to display the field as dd/mm/yy. Here is the code I have used: =date(EnterDatetime,'dd/mm/yy')

Something is going wrong with the month as it comes back as 00. For example 23/00/12 for today.

Other date functions work on the field, for example:

=month(EnterDatetime) returns Jan.

=date(EnterDatetime) returns 23/01/2012.

Any suggestions?

Thanks in advance, Michael.

lironbaram — Mon, 23 Jan 2012 12:59:40 GMT

hei you need to use capital like 'dd/MM/yy'

stephencredmond — Mon, 23 Jan 2012 13:02:23 GMT

Liron is correct.

As a rule of thumb, use capitals for dates and small letters for time:

DD/MM/YYYY hh:mm:ss

Note that "mm" means minutes while "MM" is months - which is why you are getting "00" for your month.

If you are ever in need of a reminder, look at the number format tab of any QlikView object that has one and see the "Time Stamp" format.

Regards,

Stephen

Mon, 23 Jan 2012 13:55:24 GMT

Thanks guys.