Recognizing Different Date Formats

Carolynn

When uploading String values, Domo can automatically recognize string in format "yyyy-MM-dd'T'HH:mm:ss.SSSXXX" (e.g.2014-04-03T10:42:30.000-07:00) as a date and populate date in the data source. One example is the "jira create date" field in data source. However, Domo cannot recognize string in format "yyyy-MM-dd'T'HH:mm:ss.SSS'Z'" (e.g. 2001-07-04T12:08:56.235-0700, no ":" in 0700) as date. This result in the resolution date cannot be recognized as date and certain cards that use resolution date as date value cannot be created.