topic My date field D/M/YY How to recode ? in QlikView

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

paulyeo11 — Sat, 19 Oct 2019 09:02:15 GMT

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 — Sat, 19 Oct 2019 15:37:40 GMT

Hi,

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

paulyeo11 — Sun, 20 Oct 2019 06:16:06 GMT

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 — Mon, 21 Oct 2019 22:43:19 GMT

Hi All

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

Paul

MarkWillems — Tue, 22 Oct 2019 12:12:24 GMT

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 — Tue, 22 Oct 2019 15:01:52 GMT

Hi Mark

Thank you very much. It work fine now.

Paul