Hi lovely all, I’m trying to convert a string to datetime; after several attempts, it’s quite close but still gives me an error. The original column has string values following the format 28-02-2019 20:22:37 AEDT, and I tried to convert it directly by selecting Date&Time with zone from the New type drop down; however, it gave me an error: Execute failed: Failed to parse date in row 'File0-Row5: Text ‘’ could not be parsed at index 0 [image] File0-Row5 is my first row and the value is 28-02-2019 20:22:37 AEDT and I have double checked the value, it should not have any leading spaces. Also, what I actually try to get is a Date&Time column rather then Date&Time with zone, but it seems that I’m not able to select Date&Time from the drop down due to the actual values detected. I know it’s possible to use String Manipulation to remove timezone description before converting, just wondering if there’s a way to achieve this directly using String to Date&Time. Thanks and regards, Olivia

String to Date&Time with Timezone Description

izaychik63 March 19, 2019, 1:03am 2

Try

It could work better for your case.

1 Like