Solved
Convert text of type "11 May 2021 07:08:12 GMT" to datetime
Hi Team,
I have a csv in which I am receiving "11 May 2021 07:08:12 GMT" as text in one of the columns, Is there anyway to cast to Appian datetime type
Regards
Bihitak
Hi Team,
I have a csv in which I am receiving "11 May 2021 07:08:12 GMT" as text in one of the columns, Is there anyway to cast to Appian datetime type
Regards
Bihitak
Try using parsedate function.
This is available in plugin: Date and Time Utilities
Eg: parsedate("11 May 2021 07:08:12 GMT")
Output:

Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.