topic Re: Date format problems in QlikView

Date format problems

alexandermllr — Thu, 27 Oct 2016 09:24:43 GMT

Hello,

I have problems with a date format.

I have this format:

date

115

216

1115

I want this:

date

2015/01

2016/02

2015/11

My problem is the month.

Thank you for you help

sunny_talwar — Thu, 27 Oct 2016 16:28:34 GMT

Try like this:

Table:

LOAD *,

Date(Date#(Num(Date, '0000'), 'MMYY'), 'YYYY/MM') as NewDate;

LOAD * Inline [

Date

115

216

1115

];

alexandermllr — Fri, 28 Oct 2016 06:44:37 GMT

Hi,

Thank you very much!