topic Re: String to Date. in QlikView

String to Date.

Thu, 27 Sep 2012 03:40:48 GMT

Good Day,

i have a string that like this

testtesttest 2012-12-30

but the problem is

i've already reperate the date via subfields,

but the problem is the convertion of 2012-12-30 to date.

i already use Date# then convert to Date, but the output is null.

any idea thanks!

Regards

somenathroy — Thu, 27 Sep 2012 04:57:42 GMT

Date(Date#(Right(Trim('testtesttest 2012-12-30'),10),'YYYY-MM-DD'),'DD/MM/YYYY')

sudeep_d — Thu, 27 Sep 2012 08:47:44 GMT

date(date#(right('testtesttest 2012-12-30',10),'YYYY-MM-DD'),'MM/DD/YYYY')