topic Re: Date Type changes along the table in QlikView

Date Type changes along the table

chloe — Thu, 11 Feb 2021 15:18:16 GMT

Hey,

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

How can I fix it?

Thanks.

Re: Date Type changes along the table

PradeepK — Thu, 11 Feb 2021 19:09:22 GMT

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..

Re: Date Type changes along the table

chloe — Thu, 11 Feb 2021 19:54:28 GMT

Perfect! thanks 😀

Re: Date Type changes along the table

QFabian — Thu, 11 Feb 2021 20:27:10 GMT

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: