Force a field to be a date in the loading script

[#1]

Hi,

Is it possible within the load script to force a field to be a date?
I mean, data come from QVD in a date format apparently (stored as numbers) and i would like they are automatically displayed as DATES using the LOAD SCRIPT.

Thanks a lot !

[#2 · Accepted solution]

Hi,

use

DATE(MyDateField) as OrderDate

as example.

Good luck!

Rainer

[#3]

there is also date#(mydate) how indicates to qv that is a date field

[#4]

Hi,
I think Rainer solution should work :
your date field will be sub typed as date and displayed as date by default.

Please note that QVD are much faster to load if there isn't any treatment to do, so you can also load data as usual then go in Settings / Document Properties / Number and select Date format for your field

Or you should use the date function when you load date before you create the QVD instead of using it when loading data from QVD

Hopes it helps

Regards