Qlikview file on new (licenced) computer

[Anonymous]

Hi guys,

I have made a Qlikview file on a computer and putted the Qlikview file on another licenced computer. On this laptop, the Qlikview application doesn't work properly, because all the date/time formats are interpreted different. The code is the same, the input data is the same, my question is, how can we fix this? Is het something in the settings?

This is the used code (with dynamic input name, which was the same in the case above):

LOAD *, date([Effective date], 'DD-MM-YYYY'), mid(date([Effective date], 'DD-MM-YYYY'), 4,2) as [Maand], Date(Num([Effective date]+$(InputBetaalTermijn))) AS NumericDate 

FROM $(InputBestandsNaam)

(ooxml, embedded labels, table is Sheet1);

Thanks for the help!!

[marcus_sommer]

The variables at the very first beginning in the script define how dates and times are interpreted. Another important part of the recognition are the regional-settings from the OS. Maybe here are some differences between the machines / user-profiles.

- Marcus