How to assess dates with dates

Results 1 to 2 of 2

Thread: How to assess dates with dates

  1. #1
    Join Date
    Dec 1969

    Default How to assess dates with dates

    I am trying to effeciently write a routine that will see if particular database entries have "expired" or not. <BR><BR>Assessing the specified "expiration date" located on the DB versus the Server Date. So that if the expiration date is found to be a date previous to the current system date - it would either delete or make invisible that particular entry.<BR><BR>What would be an effecient method to compare dates?<BR><BR>much thanks,<BR><BR>George <BR><BR>

  2. #2
    Franco Guest

    Default RE: How to assess dates with dates

    If you&#039re using stored procedures as your backend, add a where clause like:<BR><BR>WHERE ExpiryDate &#062; GetDate() /*for SQL Server*/<BR><BR>If you&#039re using Access, add the above to the end of the query.

Posting Permissions

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