Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Can someone please suggest why:
When I reload my QV app on my PC, the dates appear in the correct UK format… i.e. DD/MM/YYYY
But when they are reloaded on the QlikView server, they are in the American format, MM/DD/YYYY
I have checked the server and region is set to UK.
I am connecting using ODBC and both machines have been set up identically using the same driver version etc.
Whilst the date can be formatted in the script - I was hoping to understand the reason to avoid any coding.
Hi IBI-Keeble,
I have exactly the same issue with my dates language format. Did you finally find a solution to solve it ?
Thanks in advance,
Julien
Can you upload a sample document that you are having the issue with. Something small, that can be reloaded, that will show the issue?
Unfortunately, I can't.
My settings :
SET DateFormat='DD-MMM-YYYY';
Windows XP SP3 Regional Settings : French
I split my process into two steps :
Step 1 - LOAD.qvw : QlikView loads tables from the database via ODBC and store them in QVD files.
-------------------------------------------------------------------------------------------------------
MONTH:
SQL
...
TO_CHAR("MTH_END_DT",'DD-mon-YYYY') as "MTH_END_DT",
...
FROM <database>.<table>
store MONTH into MONTH.qvd(qvd);
-------------------------------------------------------------------------------------------------------
Here, date format is right, as specified in SQL code (DD-mon-YYYY). Language is english (but my regional settings are set in French). It's exactly what I want.
Ex: 02-feb-2012
Step 2 - TRANSFORM.qvw : QlikView loads in a "transform" file, all QVDs my application requires to build data model.
-------------------------------------------------------------------------------------------------------
Month:
LOAD
MTH_END_DT
FROM MONTH.qvd (qvd);
-------------------------------------------------------------------------------------------------------
As you can see, no transformation is applied on my date field. Despite that, date format gets more than 3 characters (4, 5 characters, depends on month short name) and language turns to french.
Ex: 02-févr.-2012
My questions are : What does Qlikview do with dates when it loads QVD ? How date format language is set regardless regional settings ?
Thanks in advance,
Julien