date() selection

Results 1 to 4 of 4

Thread: date() selection

  1. #1
    na8ur Guest

    Default date() selection

    I got a field named datum which has the entries<BR>12.06.99 (eg)<BR>now I want to select today --> Datum=date()<BR>but how do I select the next 7 day or evenen the next months.<BR><BR>can you help me please :-?

  2. #2
    Sam Otto Guest

    Default RE: date() selection

    today = Date<BR>newDate = DateAdd("d",7,today)<BR><BR>newDate will be 7 days in the future

  3. #3
    Join Date
    Dec 1969
    Posts
    2,849

    Default RE: date() selection

    You will need to use DateAdd. There are a couple of good articles on 4Guys that discuss how to use DateAdd:<BR><BR>http://www.4guysfromrolla.com/webtech/faq/Intermediate/faq3.shtml<BR>...and...<BR>http://www.4guysfromrolla.com/webtech/110398-1.shtml<BR><BR>You can also check out the "official" documentation at:<BR>http://help.activeserverpages.com/iishelp/VBScript/htm/vbs90.htm<BR><BR>Happy Programming!

  4. #4
    NA(UR Guest

    Default THX

    thanx a lot for the great help.<BR>watch your script in the next few weeks working at http://www.kunstmarkt.de (me is Mathias E. Koch)<BR><BR>we are http://www.betatribe.de -->sending GOODVIBES as you do <BR>again thanx<BR>/na8ur


Posting Permissions

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