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 Chriss 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
Joined
Jul 7, 2000
Messages
438
Location
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

sal21
  • Locked
  • Question Question
SORT DATE in msflexgrid not correct
Replies
4
Views
551
sal21
sal21
Swi
  • Locked
  • Question Question
Date/Time Conversion
Replies
2
Views
452
Swi
Swi
2009luca
  • Locked
  • Question Question
GET date from classname
Replies
2
Views
627
2009luca
2009luca
2009luca
  • Locked
  • Question Question
population of italy live/real time
Replies
11
Views
983
strongm
strongm
sal21
  • Locked
  • Question Question
LAST DATE OF MODIFIED FILE on WEB
Replies
4
Views
550
strongm
strongm

Part and Inventory Search

Sponsor

Back
Top