Date issue

[#1]

now, the date is showing like blow as numbers, i want it to be the date format

FieldDate

40909

40910

40911

40912

40913

40914

40915

40916

i have tried many ways

Date(FieldDate)

Date#(FieldDate, 'YY-MM-DD')

interval(fLOOR([FieldDate]),'YY-MM-DD')

all are not working, i do not know why

[tresB]

Date(FieldDate, 'YY-MM-DD') ?

[#3]

Not working

[nizamsha]

its working fine

Date( Date,'DD-MM-YY')

[tresB]

Issue must be somewhere else. Where are you trying this, script? (if yes, how?), at the front end ?(if yes, text box, or any expression?)

[nizamsha]

a:

LOAD * inline [

Date

40909

40910

40911

40912

40913

40914

40915

40916

];

LOAD

Date( Date,'DD-MM-YY') as Date1 Resident a;