Format of Date

[mohan2391]

Hi,

I have a date field as below.

How to change the format of this field to "DD/MM/YYYY" ?

Thank You....

[mohan2391]

It is not showing anything in list box.

[jjbom1990]

Using the example of chanty4u‌ :

a:

LOAD * INLINE [

    Mydate

    20150815

    20160912

];

Result1:

LOAD *,

date(Right(Mydate,2)&'-'&Mid(Mydate,5,2)&'-'&left(Mydate,4),'DD/MM/YYYY') as Date

Resident a;

Result:

LOAD *

  ,year(Date) as Year

  ,month(Date) as Month

  ,day(Date) as Day

Resident Result1;

Drop table a;

drop table Result1;

I don't know what went wrong on your side, but my code worked.

[praveenkumar_s]

try this,

Date(REV_REC_DAY,'MM/DD/YYYY') as REV_REC_DAY