Long load time due to date format

deepakqlikview_123 — Sat, 16 Nov 2024 01:01:58 GMT

Hi All,

We are retrieving data from the SQL server database. It seems that the date is in the string format.

The current transformation for the date in Qlikview is Text (Date (datetime, 'DD.MM.YYYY')) as DateTime which is consuming more time.

Could you please suggest any alternative for this.

Re: Long load time due to date format

tresB — Wed, 18 Mar 2020 08:51:36 GMT

@deepakqlikview_123 wrote:
.. Text (Date (datetime, 'DD.MM.YYYY')) as DateTime ..

Your code looks not very useful to me. If you need to convert a text field to date field, you should use date#() instead. And why text()?