topic Re: Date conversion w/ timezone in QlikView

Date conversion w/ timezone

Thu, 30 Jan 2014 15:42:38 GMT

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

Anonymous — Thu, 30 Jan 2014 16:02:37 GMT

= 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')

Thu, 30 Jan 2014 16:09:57 GMT

Thanks