How to add days to a DATE

Results 1 to 2 of 2

Thread: How to add days to a DATE

  1. #1
    Keith Fowler Guest

    Default How to add days to a DATE

    The date is pulled from a db and I need to add 30 days to it to display elsewhere. Any help would be greatly appreciated.

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

    Default RE: How to add days to a DATE

    Dim currentDate<BR>currentDate = CDate(objRecordsetObject("DateFromDB"))<BR><BR>Dim futureDate<BR>futureDate = DateAdd("d",30,currentDate)<BR><BR>You can learn all about DateAdd and other powerful date functions at:<BR><BR>http://www.4guysfromrolla.com/webtech/faq/Intermediate/faq3.shtml<BR>and<BR>http://www.4guysfromrolla.com/webtech/110398-1.shtml

Posting Permissions

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