date

[Dolly123]

i want date DD/MM/YYYY

[menta]

You can use Date(Floor(date),'Dd/MM/YYYY') 

with floor you cut the time part

[Dolly123]

not works

[BrunPierre · Accepted solution]

Hi

Try this

Date(Floor(TimeStamp#([Date Field], 'MMM DD, YYYY hh:mm TT')),'DD/MM/YYYY')

[menta]

the field in qlik is a text or a date?  If it is a text you need to work on loading script