topic Force a field to be a date in the loading script in QlikView

Force a field to be a date in the loading script

Fri, 04 Jun 2010 09:35:25 GMT

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 !

Force a field to be a date in the loading script

Fri, 04 Jun 2010 09:46:38 GMT

Hi,

use

DATE(MyDateField) as OrderDate

as example.

Good luck!

Rainer

Re. :Re: Force a field to be a date in the loading script

Fri, 04 Jun 2010 09:57:00 GMT

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

Force a field to be a date in the loading script

Fri, 04 Jun 2010 09:58:18 GMT

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