Date conversion w/ timezone

[#1]

How do I convert this timestamp into a QV Date ?

Fri, 1 Feb 2013 00:06:38 -0500

Tried the below - Created is the input field withe the time in the above format, but not sure what are the string would be for the '-0500'.

Date(Date#(Created, 'WWW, DD MMM YYYY hh:mm:ss'),'DD/MM/YYYY') As Dt

Thanks

MJ

[Anonymous]

     = Date(Date#( mid(  'Fri, 1 Feb 2013 00:06:38 -0500' , 6 , 11  )  , 'D MMM YYYY'),'DD/MM/YYYY')

or using your field name

     = Date(Date#( mid( [Created] , 6 , 11  )  , 'D MMM YYYY'),'DD/MM/YYYY')

[#3]

Thanks