Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
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
Partner - Champion III
Partner - Champion III

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
Partner - Champion III
Partner - Champion III

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

simenkg
Specialist
Specialist

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