Date Compare for output

Results 1 to 2 of 2

Thread: Date Compare for output

  1. #1
    Corin Guest

    Default Date Compare for output

    I want to do a database pull for a message of the day, how do I do the date compare if I use 31 (one for each day of the month) rows in my DB and get the result by comparing it to todays date?

  2. #2
    KPW Guest

    Default RE: Date Compare for output

    Could you associate a number with each of your database rows and then do a select on the row whose number equals Day(Date)?<BR><BR>EX:<BR><BR>sSql = "SELECT * FROM tTips WHERE iNumber = " & Day(Date)

Posting Permissions

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