Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Just use: date(date#(DateField, 'MM/DD/YYYY')) as DateField
- Marcus
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