Automatic Email

Results 1 to 2 of 2

Thread: Automatic Email

  1. #1
    Join Date
    Dec 1969

    Default Automatic Email

    I have a database with peoples names and birthdays in it and I would like an automatic email sent out when their birtday is near. I am having problems comparing the current day with the birthday. How do you compare the Month/Day of the birthday to the Month/Day of the current? For example if someone was born on:<BR>12/21/1977 how do you take apart the date an deciede it is their 24th Birthday and send out an email?<BR><BR>Hope this makes sense.<BR><BR>Kegsby

  2. #2
    Join Date
    Dec 1969

    Default RE: Automatic Email

    Convert the date to a string, split it into an array, and check the Month() and DateDiff() functions...

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts