Making records expire on date

Results 1 to 2 of 2

Thread: Making records expire on date

  1. #1
    Jeremy Botter Guest

    Default Making records expire on date

    Hey,<BR><BR>I&#039m currently working on a tour database for the Clay Walker site, and for the life of me I can&#039t remember how to make something expire once a certain date has past. I want the script to call the date from the server, not the users computer.<BR><BR>Any help would be appreciated. You can reach me at alternatively if you&#039d like.<BR><BR>Jeremy Botter<BR>Bill Young Productions<BR>This week&#039s featured site:

  2. #2
    Barkus Guest

    Default RE: Making records expire on date

    You can make records expire by using datediff.<BR><BR>For example: DateDiff(D,Field_Value,GetDate()) &#060; 30<BR><BR>GetDate () = Current Date<BR>D = Day<BR>Field_value = Record 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