Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have an SQL database with a "date" field of type date.
(screenshot from pgAdmin)
I create a QVD like this:
SET DateFormat='D/MM/YYYY';
$(vTableName):
Load *;
SELECT *
FROM $(vTableName) WHERE "date" >= '$(vCompanySplitDate)';
Store $(vTableName) into '$(vQVDFile)';
In another Qlik app, I then load this QVD like this:
My question is, what are the data types of "date" after the first step (in the QVD) and after the second step (in the "Raw" table). Date? Integer? String?
Hi,
The statement
SET DateFormat='D/MM/YYYY'
If valid till your data is in the App (Dashboard).
If you want the same format to follow in QVD, you will have to define it in Load Statement.
Load *, Date(DateField,'DD/MM/YYYY');
If you don't define it, it will use same format as you have in source.
Hi,
The statement
SET DateFormat='D/MM/YYYY'
If valid till your data is in the App (Dashboard).
If you want the same format to follow in QVD, you will have to define it in Load Statement.
Load *, Date(DateField,'DD/MM/YYYY');
If you don't define it, it will use same format as you have in source.
Great, thanks!