topic Date issue in QlikView

Date issue

johnan — Mon, 14 Sep 2009 14:04:17 GMT

Hi All!

I have a date field: 90915 (numeric)

I Want to convert to 2009-09-15

Can i do that?

Mon, 14 Sep 2009 14:08:55 GMT

Hi Johnan,

use this: date(90915, 'YYYY-MM-DD');

But 90915 is not 2009-09-15 but 2148-11-29

Rey-man

johnan — Mon, 14 Sep 2009 14:16:40 GMT

Yes, iknow.
I think we have to convert and not use date function? Or the first zero in year will doit?

Mon, 14 Sep 2009 14:17:36 GMT

Hi,

Something like this: date(date#(Num(DATE,'000000'),'YYMMDD')) as Date

But what about 2010? Will it be displayed like this: 100915?
Use the function in your script. 😉

Greetz
Robbie

johnan — Mon, 14 Sep 2009 14:50:34 GMT

That doit it 🙂
and 2010 woks.
Can i do this with a timefield to?

93126
09:31:26

Mon, 14 Sep 2009 15:00:28 GMT

Hi,

For time tyr this: time(time#(Num(F2,'000000'),'hhmmss')) as Time

Greetz
Robbie

johnan — Mon, 14 Sep 2009 15:10:42 GMT

Thanx, this works!