Parse XML to CDT

Hi All,

We are trying to parse XML to CDT using xpathsnippet function and we are successful in converting "Text" data types from XML. When we try to convert date time fields from XML, it is getting converted as "Text". How to convert this text back to date time? We tried with todatetime() function and facing some issues, its converting text to date time in different time zone (GMT+11:00). I'm not sure from where it is taking GMT+11:00 time zone as my preferred time zone is GMT+10:00.

Please suggest!!

 

Thanks.

  Discussion posts and replies are publicly visible