Change format to load field data "date"

[#1]

Hi

The source I load has a field called "date" with format YYMMDD.

I have trouble to get this data loaded into QV so It appers correct.

for examle

090103 appers as 2146-09-09

Can I in the load script define this field to get correct format?

Thankful for all help

BR

Malte

[marcus_malinow]

Hi Malte,

use the expression

Date#(date, 'YYMMDD') as date

in your load script.

Marcus

[#3]

Great! Thank you Marcus!

[Michiel_QV_Fan]

date(date#(date, 'YYMMDD'), 'DD-MM-YYYY') as Date

This sets how the date should be read, Date#()

And how you want to have it displayed, if other than specified in the main tab. Date()