Skip to main content

QlikView Integrations

Discussion Board for collaboration on QlikView Integration.

Announcements
Welcome to Qlik Community! Check out our new navigation! FIND OUT MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
antupe
Contributor III
Contributor III

Date formating

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:

antupe_0-1651487235527.png

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:

antupe_1-1651487882646.png

Any idea of why this could be happening?

Thank you in advance

 

Labels (1)
1 Solution

Accepted Solutions
vchuprina
Specialist
Specialist

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

vchuprina_0-1651488708691.png

Regards,

Vitalii

Press LIKE if the given solution helps to solve the problem.
If it's possible please mark correct answers as "solutions" (you can mark up to 3 "solutions").

View solution in original post

2 Replies
vchuprina
Specialist
Specialist

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

vchuprina_0-1651488708691.png

Regards,

Vitalii

Press LIKE if the given solution helps to solve the problem.
If it's possible please mark correct answers as "solutions" (you can mark up to 3 "solutions").
antupe
Contributor III
Contributor III
Author

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