topic Re: Problem with the Date field in QlikView

Problem with the Date field

mohanrajsubrama — Thu, 11 Jun 2015 10:46:08 GMT

Hi Team,

I have a 2 tables with date columns .In one of the table the date column format is MM/DD/YYYY .

In another table the date column is like 20050617.ie(yearmonth and date is combined).

Could you guys help me to resolve this .

i want 20050617 to be like MM/DD/YYYY format.

Thanks in Advance

Mohan

Anonymous — Thu, 11 Jun 2015 10:48:08 GMT

Try using left,right and mid function and concatenate to the format you want.

sushil353 — Thu, 11 Jun 2015 10:48:20 GMT

Try:

Date(Date#('20050617','YYYYMMDD'),'MM/DD/YYYY')

HTH

Sushil

fvelascog72 — Thu, 11 Jun 2015 10:48:26 GMT

Hi,

Try this:

Date(Date#(DATEFIELD,'YYYMMDD'),'MM/DD/YYYY') as DATEFIELD

Joaquin_Lazaro — Thu, 11 Jun 2015 10:48:49 GMT

Hi:

Date(Num(Date1), 'YYYY/MM/DD) as Date1

Date(Num(Date2), 'YYYY/MM/DD) as Date2

Hope this helps you

Joaquín

mohanrajsubrama — Thu, 11 Jun 2015 12:06:42 GMT

Hi Dass,

The same i did and it worked using makedate function.

Thanks,

Mohan