Your script (the piece of code you need to write to pull data from the database and put into memory) will look like the following
Table: // table labelLOAD TransID, // this are the fields you are loading into QlikView's memory CustID, Date(Date#(DateField, 'DD-MMM-YY')) AS DateField;SQL SELECT TransID, CustID, DateFieldFROM Table.Datasource;
The above is just an example just to see how to do the conversion in the load script, so change it to fit your needs.
Hope that makes more sense.
Miguel Angel Baeyens wrote:
Try the following in your load script:
<blockquote><pre>Date(Date#(DateField, 'DD-MMM-YY')) AS DateField
Hope that helps.
You need to do that in the load script and you and you will have to swap DateField for your date fields, and probably do it for each of you date fields
My load script looks like this:
SET MoneyFormat='R #,##0.00;R-#,##0.00';
SET TimeFormat='hh:mm:ss TT';
SET TimestampFormat='YYYY/MM/DD hh:mm:ss[.fff] TT';
LOAD [Product Name],
[Account open date],
and then the rest of my field names, and then
(txt, codepage is 1252, embedded labels, delimiter is '~', no quotes, header is 1 lines);
So if I have a field named [Account Open Date], where exactly should I enter Date(Date#([Account Open Date], 'DD-MMM-YY')) AS [Account Open Date]