AnsweredAssumed Answered

Automate a Date Find

Question asked by Pizon on Nov 7, 2009
Latest reply on Nov 9, 2009 by philmodjunk

Title

Automate a Date Find

Post

I have a DB of about 1500 records consisting of several fields (Names,Phones, and DOB).

 The important field is DOB (date of birth). My goal is to do a find for those DOBs that fall on today, CurrentDate.

 

I need to match the Month and Day of DOB with the Month and Day of the  CurrentDate;

the year isn't important.

I would like to automate this "find" when I open this DB.

 

Would you give me a little "push" in the right direction?

 

Calculations fields employed thus far:

MM                          Calculation          =Month(DOB)

DD                                  "                   =Day(DOB)

CurrMonth                     "                   =Month(Get(CurrentDate))

CurrDay   "                        =Day(Get(CurrentDate))

 

Thanks in advance for any help you might provide!! 

Outcomes