Hi,

I can't find exact solution for this so apologies if it already exists. I can't control the incoming data (Mailchimp Cloud Connector) but from the error logs an example date format is:

3/25/2020 7:26:20 AM

If I strip the timestamp then I get the invalid fuzzy date error, support have told me you can only apply one line of a dictionary so I need a one liner that'll strip the timestamp and also reformat to UK date format DD/MM/YYYY

Please help me RegEx gurus! :)

Cheers,

Michael

Hi Michael

This is what we use:

Now this incorporates time as well as no time stamp, and I haven't looked at it for a while, so I think it is best to try a few of the rows above, and play around as you need.

Gemma

Thanks Gemma but my date format is different and that's not working. I don't know regular expressions but I've played around and can't get anything to work (running tests just returns the input value). I think I need to remove the timestamp and reformat the date but also I suspect the fact that the day is only 1 char if less than 9 will also need to be handled, not sure. 

Thanks again for your input though!

This is what I use:

Values to match on:

First line: (?<=[0-9]{4}).*

Second line: (?<=2010).*

Third line: (?<=2011).*

Hope this works for you.

Barbara