---
title: Converting Date/Time Fields with Regex
slug: user-guide-10x/converting-datetime-fields-with-regex
docTags: 
createdAt: 2025-12-15T16:05:36.173Z
---

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:

![](https://api.archbee.com/api/optimize/n8uUzk0MM4uC57-zlHNtY/SBlUyi9-GILYaTG5-sOw1_image.png)

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:

1. Find the field option that sets the Date & Time field in question.
2. Select “*Parse With*”:

![](https://api.archbee.com/api/optimize/n8uUzk0MM4uC57-zlHNtY/duZeydWjppzJXXeTDb1xt_image.png)

3. Choose the “*Regex*” option:

![](https://api.archbee.com/api/optimize/n8uUzk0MM4uC57-zlHNtY/4M4ITo6hZElSPx7BcR_Eg_image.png)

4. Edit the Regex parse:

![](https://api.archbee.com/api/optimize/n8uUzk0MM4uC57-zlHNtY/_rBMbDYaWta_uYOWaIQyx_image.png)

5. Fill out the *Regular Expression* and *Test Data* fields:

![](https://api.archbee.com/api/optimize/n8uUzk0MM4uC57-zlHNtY/j8fPBiaYZT1W6qvVImiZF_image.png)

6. Test the configuration:

![](https://api.archbee.com/api/optimize/n8uUzk0MM4uC57-zlHNtY/SJQjXSfnR66HvGHSc4YEy_image.png)

In this case, the regular expression removes the timezone specific values at the end of the string to match the Standard format.