Start a new topic

Regular Expression Day of Month


I am currently importing installments for a pledge.  I need to convert a date (MM/DD/YYYY) into the Schedule Day of Month (DD).  Is there a regular expression for this?  Many thanks in advance for your help.

Thank you!

Lisbeth Fernandez

1 person has this question

Thank you! Worked great!

Here is one that can generate the month name based on the date. Great for Annual installment frequencies....


Please feel free to copy from below into your dictionary. You can now copy the gift date and use in virtual fields to get the "Schedule Month" for annual installments. 

January ^01+/\d{1,2}/\d{4}$ TRUE
January ^1+/\d{1,2}/\d{4}$ TRUE
February ^02+/\d{1,2}/\d{4}$ TRUE
February ^2+/\d{1,2}/\d{4}$ TRUE
March ^03+/\d{1,2}/\d{4}$ TRUE
March ^3+/\d{1,2}/\d{4}$ TRUE
April ^04+/\d{1,2}/\d{4}$ TRUE
April ^4+/\d{1,2}/\d{4}$ TRUE
May ^05+/\d{1,2}/\d{4}$ TRUE
May ^5+/\d{1,2}/\d{4}$ TRUE
June ^06+/\d{1,2}/\d{4}$ TRUE
June ^6+/\d{1,2}/\d{4}$ TRUE
July ^07+/\d{1,2}/\d{4}$ TRUE
July ^7+/\d{1,2}/\d{4}$ TRUE
August ^08+/\d{1,2}/\d{4}$ TRUE
August ^8+/\d{1,2}/\d{4}$ TRUE
September ^09+/\d{1,2}/\d{4}$ TRUE
September ^9+/\d{1,2}/\d{4}$ TRUE
October ^10+/\d{1,2}/\d{4}$ TRUE
November ^11+/\d{1,2}/\d{4}$ TRUE
December ^12+/\d{1,2}/\d{4}$ TRUE
When using 11/1/2013 8:26 with the regular expression above along with the regualr expression to delete the time from the end - I get January as the answer. Can you have two regular expressions?

Thanks So Much
If you have the mm/dd/yy value ( two digit year as opposed to four digit year) then use the following formula


You can do it all in one dictionary

Replace  Match
 01$1 (\d+)-Jan
 02$1 (\d+)-Feb
 03$1 (\d+)-Mar

And so on...

Make sure to check "use Regular Expressions"!

Login or Signup to post a comment