Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Date time

Status
Not open for further replies.
EscapeUK

EscapeUK

Programmer
Jul 7, 2000
438
GB
I have a text box that displays the date and time,

How to I add two hours on to the date.

Sometimes I also need to add a day

 
Sort by date Sort by votes
Use the Dateadd function like this :

Dateadd(interval,number,date)

To add two hours :
Dateadd("h",2,date)

PK Odendaal
pko@mweb.co.za

 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Swi
  • Locked
  • Question
Date/Time Conversion 1
Replies
2
Views
177
Swi
Swi
2009luca
  • Locked
  • Question
GET date from classname
Replies
2
Views
298
2009luca
2009luca
2009luca
  • Locked
  • Question
population of italy live/real time
Replies
11
Views
397
strongm
strongm
sal21
  • Locked
  • Question
LAST DATE OF MODIFIED FILE on WEB 1
Replies
4
Views
206
strongm
strongm
sal21
  • Locked
  • Question
very slow to create at run time listview
Replies
7
Views
283
strongm
strongm

Part and Inventory Search

Sponsor

Back
Top