Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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')
Hi,
Try with Date( Date#([Month], 'D/M/YY'), 'DD/MM/YYYY') as [date]
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
Hi All
Can some one advise me . As I can see the date at excel .
Paul
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')
Hi Mark
Thank you very much. It work fine now.
Paul