Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
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