Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor III
Contributor III

Date format are different

Hi, im new in QlikView and in make a board to integrate data from different databases and all well fine, but when i try to  see this values in a chart some data is not there and found a strange problem with dates and i don't know how to fix it, i attached a image

errordefecha.png

 

Regards

Isaias

Tags (3)
Labels (1)
1 Solution

Accepted Solutions
Highlighted
Contributor III
Contributor III

Re: Date format are different

Thanks to all, i resolve this with the function MakeDate

View solution in original post

13 Replies
Highlighted
Partner
Partner

Re: Date format are different

In you script where you are loading Fetcha. change it to something like below
Date(Fetcha, 'YYYY-MM-DD') as Fetcha,
Highlighted
Contributor III
Contributor III

Re: Date format are different

Hi Dilipranjith,

I have dealt with that but it does the same

Highlighted
Partner
Partner

Re: Date format are different

Whats the data type for the field in the data model?
Highlighted
Contributor III
Contributor III

Re: Date format are different

I think it's a subject of the databases, in both the data type is date but the collage are different in one is Modern_Spanish_CI_AS and the other isLatin1_General_CI_AS, could it be that? and if so, how do I fix it?
Highlighted
Partner
Partner

Re: Date format are different

You have to fix it when you load it.
Maybe try combination of date(date#(field, 'DBDATEFormat'),'YouDesiredDATEFORMAT')
Highlighted
MVP & Luminary
MVP & Luminary

Re: Date format are different

Without any measures on the fields by loading the data will be a date only interpreted as date if it has the format as in the default-variables (at the beginning of the script). This means you need to convert and format all date-fields which are different to it. This could be done with: date(date#(DATE, 'FormatString')) and if there are multiple different formattings within a single field maybe with: alt(date(date#(DATE, 'FormatString1')), date(date#(DATE, 'FormatString2'))).

- Marcus

Highlighted
Master II
Master II

Re: Date format are different

the upper dates are in string so use date(date#(Fecha,'YYYY-MM-DD'),'DD/MM/YYYY')

If you  have diffrent formats try 

alt(your expression,date(date#(Fecha,'YYYY-MM-DD'),'DD/MM/YYYY')) and it shall fetch all the dates properly

Learning never stops.
Highlighted
Contributor III
Contributor III

Re: Date format are different

Hi to all,

I will try your solutions but the result are the same, check the picture

errordefecha02.png

 

 

Highlighted
Master II
Master II

Re: Date format are different

alt(date(date#(Fecha,'DD/MM/YYYY'),'DD/MM/YYYY'),date(date#(Fecha,'YYYY-MM-DD'),'DD/MM/YYYY'))
Learning never stops.