topic Re: How to convert text to Date format in QlikView

How to convert text to Date format

Anonymous — Thu, 07 Jun 2018 11:47:26 GMT

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 — Thu, 07 Jun 2018 14:13:32 GMT

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

- Marcus

praveenkumar_ma — Fri, 08 Jun 2018 05:53:19 GMT

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