topic Date format in QlikView

Date format

johnan — Sat, 17 Oct 2009 14:46:08 GMT

Hi,

I have from DB = 20091010

and time 14934

I want to format date to 2009-10-10
And the time to 01:49:34

Sat, 17 Oct 2009 15:07:19 GMT

In one of my cases I did like this:

1. Parsed the day, month and year for date and hour,minute,seconds from time.

2. Used makedate() and maketime() to derive the date and time in the desired format.

Would this help?

--Arun

johnan — Sat, 17 Oct 2009 15:17:21 GMT

Hi, no i'ts not working

Sat, 17 Oct 2009 15:31:37 GMT

Oops...

But something like this should work...?

date(MakeDate(left(Date,4),mid(Date,5,2),right(Date,2)),'YYYY-MM-DD')

where Date is your input.

--Arun

johnan — Sat, 17 Oct 2009 15:45:56 GMT

Hmm, todays date give me 40103 now

Sat, 17 Oct 2009 16:02:06 GMT

If your DB is a string, definitly this should work. See my example, below expression in a text box gives me the correct result:

=date(MakeDate(left('20091009',4),mid('20091009',5,2),right('20091009',2)),'YYYY-MM-DD')

If DB is numeric, can't we use similar numeric functions to parse? May be I'm thinking too basic than what you expect..

--Arun