Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi Malte,
use the expression
Date#(date, 'YYMMDD') as date
in your load script.
Marcus
Great! Thank you Marcus!
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()