Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On May 18th at 10AM EDT we will answer your QlikView questions live. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
siva_boggarapu
Creator II
Creator II

How to make all rows date into one date format

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

1 Solution

Accepted Solutions
alexandros17

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

View solution in original post

2 Replies
alexandros17

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

View solution in original post

simenkg
Partner
Partner

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