Date convert

[kimchiuri]

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]

https://community.qlikview.com/thread/5891

[MK_QSL]

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

];