How to convert text to Date format

[Anonymous]

Hi Expert,

My Date field format is "MM/DD/YYYY'.

After loading the data inrto Qlikview , when i select on  filter that tme  format will gone in Chart level(It's automatically chang to Text format)

How to achive this...

Thanks,

Nani

[marcus_sommer]

Just use: date(date#(DateField, 'MM/DD/YYYY')) as DateField

- Marcus

[praveenkumar_ma]

Try this

Date# evaluates an expression as a date in the format specified in the second argument, if supplied.

Syntax:

Date#(text[, format])

Hope it Helps..

Thanks

PM