Problem with date type in Qlikview

[#1]

Hi,

I got the date in a field named DDEX and I loaded into an object TEXT.

In the object TEXT, the date appears as: 01/01/2007 00:00:00.

But I would like it displayed as: 01/01/2007 only.

What to do in this case?

Thank you for your help

[#2]

Toujours sans succès

[martin59]

tu as vérifié que ta variable avait bien la bonne valeur ?

Sinon, envoie moi une partie de ton application que je puisse faire quelques tests

[#4]

Voila mon application.

Martin, l'instruction que tu m'a envoyé.

Elle est a la fin du script du premier onglet et je l'ai mise en commentaires

[mmisfeldt]

Because their field is loaded as text in which case the QlikView can not convert this text to date

Try loading it as number using functions of the NUM () or EVALUATE () and then convert it to date