Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor
Contributor

How to convert text to Date format

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

2 Replies
Highlighted
MVP & Luminary
MVP & Luminary

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

- Marcus

Highlighted
Partner
Partner

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