topic Date formating in QlikView

Date formating

antupe — Mon, 26 Jan 2026 16:26:21 GMT

Hello, I am loading data from an excel file and I am having some trouble with the date.

When I load the field that contains the date (without using date functions) it appears like this:

In order to transform the date field into the format DD-MM-YYYY I use the following formula:

Date(Floor( Date#([OrderDate], 'DD-MMM-YYYY hh:mm:ss')), 'DD-MM-YYYY'),

but when I do this, for some reason some of the dates disappear:

Any idea of why this could be happening?

Thank you in advance

Re: Date formating

vchuprina — Mon, 02 May 2022 10:51:22 GMT

Hi,

Qlik uses values in MonthNames variables, one of your date values is 13-Ene-2020, looks like Qlik doesn't recognize Ene as a month. So you should update the value in the MonthNames variable or update this value in your data source

Regards,

Vitalii

Re: Date formating

antupe — Tue, 03 May 2022 09:29:12 GMT

Thank you! I changed it and it did work properly yesterday but today it is giving me error again... I will keep checking