topic Re: Convert String to Date in QlikView

Convert String to Date

anuradhaa — Mon, 08 Feb 2016 08:58:06 GMT

I have below String and want to convet it to date

Dec 2, 2012

Chanty4u — Mon, 08 Feb 2016 09:00:33 GMT

Hi,

=num('Dec 2, 2012')

Chanty4u — Mon, 08 Feb 2016 09:02:14 GMT

=Num(Timestamp#(FieldName, 'YYYY-MM-DD '))

=Num(Timestamp#('2015-05-26 12:34:38', 'YYYY-MM-DD hh:mm:ss'))

tamilarasu — Mon, 08 Feb 2016 09:02:59 GMT

Try,

Date(Date#('Dec 2, 2012', 'MMM DD, YYYY'))

MK_QSL — Mon, 08 Feb 2016 09:05:21 GMT

Back end in script..

Date(Date#('Dec 2, 2012','MMM D, YYYY')) as YourDateField

Date(Date#(YourDateField,'MMM D, YYYY')) as YourDateField

front end

=Date(Date#('Dec 2, 2012','MMM D, YYYY'))

orDate(Date#(YourDateField,'MMM D, YYYY'))

ramasaisaksoft — Mon, 08 Feb 2016 09:07:53 GMT

Hi Anu,

if this is a single value

=num(Dec 2, 2012)

else if it is field select the filed into list box and go to Number tab of a list box

Chanty4u — Mon, 08 Feb 2016 09:14:30 GMT

hi,