Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

cancel
Showing results for 
Search instead for 
Did you mean: 
Bikoman
Contributor II
Contributor II

date format not recognized

hey, I pull my data from an excel file and I have a date format that looks like this:

Capture.PNG
when I look in the cell it looks like this: 5/18/2015 12:00:00 AM 
qlik won't recognize any of the dates... (in the excel it is a custom date).

 

Labels (2)
1 Solution

Accepted Solutions
JordyWegman
Partner
Partner

You can mark the post with the right answer as 'Solved'. Then you closed the post.

Jordy

Climber

Work smarter, not harder

View solution in original post

10 Replies
arulsettu
Master III
Master III

Try like this

Date(date filed) as date

or

 Date(Floor(date field)) as date

JordyWegman
Partner
Partner

Hi Bikoman,

You have to interpret the field first. This way Qlik knows what you are doing. This is done with the # fields like Date#. Afterwards I use the Date() for the right formatting.

Try this:

Date(Date#([YourField],'MM/DD/YYYY h:mm'),'MM/DD/YYYY')

Jordy

Climber

Work smarter, not harder
Bikoman
Contributor II
Contributor II
Author

not sure how to do it, I mean I am trying that the data will automatically load correctly.
if I understand your suggestion then you want me to put it in a formula in the analysis, which I don't want to do because I want qlik to recognize this problem when loading the data.

I thought that the solution will be something relating to the dataloader..

Bikoman
Contributor II
Contributor II
Author

not sure what you are referring to please look at what I wrote to JordyWegman maybe that will clarify the problem.

JordyWegman
Partner
Partner

What is the outcome that you want? What do you want to see when the load is finished? 

This solution is related to the Qlik Script Editor.

Jordy

Climber

Work smarter, not harder
jonathandienst
Partner
Partner

>>I thought that the solution will be something relating to the dataloader..

Yes, that is the idea. Use the above expression in your load script.

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Bikoman
Contributor II
Contributor II
Author

dont know what the problem was, something in the excel format. tried to fix it through the excel and it worked..

JordyWegman
Partner
Partner

Good that it worked! Please close the post.

Jordy

Climber

Work smarter, not harder
Bikoman
Contributor II
Contributor II
Author

I am not familiar with the forum how do I do that?