Converting Date/Time Fields with Regex

if you’ve run into the following error "job ae1wgxmyfxdd274zv failed value mon, 3 aug 2020 18 43 58 +0700 (+07) cannot be converted to standard date or time for field date & time" you’re seeing this error because the string being passed to a field of type date & time does not match the expected format the format for fields is set in following location in the swimlane ui by default, swimlane uses the standard option, which follows the iso 8601 standard to work around the error, a regex must be used to parse the string (please refer to this site for help with creating a regular expression) in this example, the following strings will be used mon, 03 aug 2020 14 39 07 +0300 (works with standard format) mon, 3 aug 2020 18 43 58 +0700 (+07) (does not work includes time zone) to resolve the error find the field option that sets the date & time field in question select “ parse with ” choose the “ regex ” option edit the regex parse fill out the regular expression and test data fields test the configuration in this case, the regular expression removes the timezone specific values at the end of the string to match the standard format