Discussion Board for collaboration related to QlikView App Development.
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.
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
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.