Results 1 to 4 of 4

Thread: get date from a week ago

  1. #1

    Thread Starter
    Hyperactive Member Steve Stunning's Avatar
    Join Date
    Jul 1999
    Location
    Fairfax, Virginia
    Posts
    314

    Question


    Greetings and Salutations!

    I would like to know how I can get a date formatted minus seven days from todays date and also one month prior.

    Thank you for reading this and any help you can provide.


    Steve Stunning

  2. #2
    Guest
    You can do this with the DateAdd() function like so:

    dteWeekAgo = DateAdd("d", -7, Date)
    dteMonthAgo = DateAdd("m", -1, Date)

    Paul

  3. #3
    Frenzied Member sebs's Avatar
    Join Date
    Sep 2000
    Location
    Aylmer,Qc
    Posts
    1,606
    datevalue(Now-7)

  4. #4

    Thread Starter
    Hyperactive Member Steve Stunning's Avatar
    Join Date
    Jul 1999
    Location
    Fairfax, Virginia
    Posts
    314

    Excellent!!!

    A big thanks to both of you!!! That works just fine.
    Steve Stunning

Posting Permissions

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



Click Here to Expand Forum to Full Width