My date field D/M/YY How to recode ?

[paulyeo11]

Hi All

My date field as below :-

Month

D/M/YY

I try below , it does not work :-

Date( Date#([Month], 'DD/MM/YY'), 'DD/MM/YYYY') as [date],

Hope some one can advise me.

Paul Yeo

[sergio0592]

Hi,

Try with Date( Date#([Month], 'D/M/YY'), 'DD/MM/YYYY') as [date]

[paulyeo11]

Hi All

I try below script :-

Month as date8,

Date( Date#([Month], 'D/M/YY'), 'DD/MM/YYYY') as [date9],

It return nothing. May i know where it go wrong ?

Paul

[paulyeo11]

Hi All

Can some one advise me . As I can see the date at excel . 

Paul

[MarkWillems · Accepted solution]

It's already a date field, it doesn't need Date#.  Date(Month,'DD/MM/YYYY') gives you the value you need 

I tested this by changing the second list box for date9 (LB22510) use the following expression:

=Date(date8,'DD/MM/YYYY')

[paulyeo11]

Hi Mark

Thank you very much. It work fine now.

Paul