Start a new topic

DATE RANGE for RegExpress from two separate Columns

 Hello, 
I've created an online dictionary for our online donations. 
One particular designation name is linked to two separate FUND/APPEAL names in our
Raiser's Edge database. Is there any way of also adding a formula to
create a date range for that online dictionary ? To be more precise: the designation name and date are in separate columns... so I would need the formula to take the date from e.g. column C  while the designation name is in column K and know to still apply that designation name  to th eproper FUND/APPEAL  based on date range in column C

e.g. Donations coming in with Designation " Matching Gift" between
May 01- May 31 = apply FUND/APPEAL (A)

e.g. Donations coming in with Designation " Matching Gift" between
June 01- June 30 = apply FUND/APPEAL(B)

To be more precise: the designation name and date are in separate columns... so I would need the formula to take the date from e.g. column C  while the designation name is in column K and know to still apply that designation name  to th eproper FUND/APPEAL  based on date range in column C

Thank you

-Diana  ( Ottawa-ON, Canada)

Login or Signup to post a comment