Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Try using left,right and mid function and concatenate to the format you want.
Try:
Date(Date#('20050617','YYYYMMDD'),'MM/DD/YYYY')
HTH
Sushil
Hi,
Try this:
Date(Date#(DATEFIELD,'YYYMMDD'),'MM/DD/YYYY') as DATEFIELD
Hi:
Date(Num(Date1), 'YYYY/MM/DD) as Date1
Date(Num(Date2), 'YYYY/MM/DD) as Date2
Hope this helps you
Joaquín
Hi Dass,
The same i did and it worked using makedate function.
Thanks,
Mohan