QlikView Date fields

[hic]

QlikView has an intelligent algorithm to recognize dates independently of which region you are in. In most cases, you will have no problems loading them. It just works and you do not need to think about it. However, in some cases dates are not properly recognized and then you need to add some code in the script to make it work.

HIC

[Luisanabria]

Hi 

I have a dude: l have this mistake in my master calendar

Autogenerate: generate count is negative

El error se ha producido aquí:

CalTemp: LOAD DATE(  + ROWNO() -1) AS TempDate AUTOGENERATE - +1

I think that mistake comes from my field DATE(Fecha) because format is in this way or maybe in text format

and l want in format DD/MM/YYYY, l tried using Date#() but it doesnt change anything

Could you help me how can l solve this?