String to Date.

[#1]

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 · Accepted solution]

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

[sudeep_d]

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