Start a new topic

RegEx for converting date/time into date

We have a client who is importing files that were provided by Convio.  Convio formatted the date/time as Sep 10, 2010 11:33:51 AM or Nov 2, 2010 9:15:33 AM, etc.  When this date was imported into an RE fuzzy date field - in this case to a constituent code date from field - RE saved them with the wrong year (9/10/2000 and 11/2/2000).  So it is necessary to convert the date/time to date only for importing so that the RE fuzzy date field can save them correctly.

To do this, we created a dictionary that changes anything following '2010' or '2011' to blank:

image



1 person has this question
Login or Signup to post a comment