Start a new topic

Regular Expression Add Days to a Date

Hello Everyone!

I am importing pledges and need to add the Date of 1st pay (First Installment).  It needs to be 16 days from the gift date.  I have the gift date in the file, but was looking for a regular expression that would add 16 days to the date date column.  Any help would be greatly appreciated!

Thank you,

Lisbeth


I am not sure you can do this with a dictionary since regular expressions don't handle dates. A simple custom function will do this easily though!

See this thread for some ideas
https://www.omaticsoftware.com/Forums/tabid/108/aft/1513/Default.aspx#3995

What you want to do is much simpler than what they want to do but it will show you how to create a custom function and work with dates.
Thank you!
Login or Signup to post a comment