Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Bikoman
New 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).

 

Tags (3)
Labels (3)
6 Replies
arulsettu
Honored Contributor III

Re: date format not recognized

Try like this

Date(date filed) as date

or

 Date(Floor(date field)) as date

Partner
Partner

Re: date format not recognized

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
New Contributor II

Re: date format not recognized

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
New Contributor II

Re: date format not recognized

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

Partner
Partner

Re: date format not recognized

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
MVP
MVP

Re: date format not recognized

>>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