topic How to make all rows date into one date format in QlikView

How to make all rows date into one date format

siva_boggarapu — Fri, 18 Jul 2014 13:35:39 GMT

Hi All,

PFA. In the attachment date field showing some rows are showing correct date formart and Some rows are showing incorrect date format. I would like make them into one type of any format.

Can any one guide me how to form all rows in one format.

Thanks,

Siva

Re: How to make all rows date into one date format

alexandros17 — Fri, 18 Jul 2014 13:38:16 GMT

Probably you are reading a field coming from 2 differen sources, one with correct dates and another without.

If the scenario is correct, identify correct date formatting and ally to the second set of data.

Let me know

Re: How to make all rows date into one date format

simenkg — Fri, 18 Jul 2014 13:43:20 GMT

Try this in the script where you load your PROCESS_DATE

Date(num(PROCESS_DATE),'YYYY-MM-DD') as PROCESS_DATE

If this does not work, please post the two different possibilities for the field as it is read into the script.

Regards

SKG