Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
mohanrajsubrama
New Contributor II

Problem with the Date field


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

Tags (1)
5 Replies
jebamalai
Valued Contributor

Re: Problem with the Date field

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

sushil353
Honored Contributor II

Re: Problem with the Date field

Try:

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

HTH

Sushil

Partner
Partner

Re: Problem with the Date field

Hi,

Try this:

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

joaquinlr
Valued Contributor II

Re: Problem with the Date field

Hi:

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

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


Hope this helps you


Joaquín

mohanrajsubrama
New Contributor II

Re: Problem with the Date field

Hi Dass,

The same i did and it worked using makedate function.

Thanks,

Mohan