Date format are different

[EternalDX]

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

Regards

Isaias

[dplr-rn]

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

[EternalDX]

Hi Dilipranjith,

I have dealt with that but it does the same

[dplr-rn]

Whats the data type for the field in the data model?

[EternalDX]

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?

[dplr-rn]

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

[marcus_sommer]

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

[pradosh_thakur]

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

[EternalDX]

Hi to all,

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

[pradosh_thakur]

alt(date(date#(Fecha,'DD/MM/YYYY'),'DD/MM/YYYY'),date(date#(Fecha,'YYYY-MM-DD'),'DD/MM/YYYY'))