Problem with the Date field

[mohanrajsubrama]

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]

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

[sushil353]

Try:

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

HTH

Sushil

[fvelascog72]

Hi,

Try this:

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

[Joaquin_Lazaro]

Hi:

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

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

Hope this helps you

Joaquín

[mohanrajsubrama]

Hi Dass,

The same i did and it worked using makedate function.

Thanks,

Mohan