How to make all rows date into one date format

[siva_boggarapu]

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

[alexandros17 · Accepted solution]

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]

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