+ Reply to Thread
Results 1 to 2 of 2

Date Control Functions

  1. #1
    Webtekr
    Guest

    Date Control Functions

    Hi everyone,

    What i want to do is delete the information automatically of back date like is their any query which automatically delete information 4 years old.

    Is there something I can type into the "<now()" criteria to specify four
    years?

    Plz give me ur suggestions...

    Thanks
    Last edited by Webtekr; 03-02-2009 at 05:28 AM.

  2. #2
    J.wills
    Guest

    Re: Date Control Functions

    Hi,
    You can use the DateAdd() function:
    <DateAdd("yyyy",-4,now())

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1