topic Date convert in QlikView

Date convert

kimchiuri — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

In then db I am loading I have dates columns represented as varchar (mysql) as YYYY-DDDT00:00:00.000.

it is clearly Year and day of the year.

Any out of the box function in QLIK to make out of it a standard date; e.g. dd/mm/yyyy?

Thanks

Uri

MK_QSL — Tue, 29 Nov 2016 14:29:51 GMT

MK_QSL — Tue, 29 Nov 2016 14:38:51 GMT

Data:

Load *,Date(MakeDate(Left(DateTimeField, 4))+(Mid(DateTimeField,6,3))) as DateField Inline

[

DateTimeField

2016-010T00:00:00:000

2016-140T00:00:00:000

2016-365T00:00:00:000

];