Results 1 to 3 of 3

Thread: dates...

  1. #1
    Join Date
    Aug 2003
    Posts
    64

    Unanswered: dates...

    this is easy?

    not sure what to put in the criteria of the query date field, but how can I show the prior date when showing the days within the look up table.

    let's say the days has 08/18/03 but I would like it to show 08/17/03 or subtract a day from the list of days from the date field.

  2. #2
    Join Date
    Jul 2003
    Posts
    48

    Re: dates...

    DateAdd("d",-1,[DateField])

  3. #3
    Join Date
    Aug 2003
    Posts
    64

    Cool Re: dates...

    Originally posted by bscorer
    DateAdd("d",-1,[DateField])


    thanks

Posting Permissions

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