Date Type changes along the table

[chloe]

Hey,

I have an issue with my StartDate column, the type of the column changes as below:

How can I fix it? 

Thanks.

[PradeepK]

Looks like Field value is not consistent.. Look into field $Tags.. it should $date and not $text

Use Date#() function to parse text date field correctly.

Tip : You can also look into Alt() function if date format is changing..

[chloe]

Perfect! thanks 😀

[QFabian]

Hello @chloe , it is important to consider that Qlik defines some initial variables in the script, and two of them define the date formats and separators: