Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2004
    Location
    Hong Kong
    Posts
    29

    Unanswered: About Date Function

    Hi

    There is a Date field in my programme. I need to retrieve record that is between the Date and 30 days before. Can somebody help

    cchan

  2. #2
    Join Date
    Dec 2002
    Location
    Préverenges, Switzerland
    Posts
    3,740
    try query criteria
    between DateAdd("d", -30, Date) and Date

    ...but take care - Date is a reserved word: don't call things "Date"

    izy
    currently using SS 2008R2

Posting Permissions

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