Change Date from Characters to Number : Omatic Support

How can we help you today?

Start a new topic

Change Date from Characters to Number

Shelby McNabb

started a topic about 1 month ago

A repot I am pulling is formatting the date as follows: "Dec 16 2020 5:01PM PST." I have the regular expression to remove the timestamp, but is there a way to change the words to 12/16/2020?

1 Comment

Barbara Daenzer

said about 1 month ago

I'd start by seeing if you can change the output from the data source. That would be an easier route and should be an option.

More topics in ImportOmatic

Dictionary Issue- RegEx to translate dollar amount to specific letter code
Preventing IoM from importing Blank Attributes
Dictionary default United States?
How to not add a gift attribute if the import cell is blank
RegEx to remove leading characters
Credit Card type Dictionary
Regular Expression to pull a specific word or string from a longer string
Object reference not set to an instance of an object Error
Event Participant importing question
Date Dictionary Help: YYYYMMDD to MM/DD/YYYY

See all 1146 topics

Help Desk Software by Freshdesk