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!
-
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!
-
DateAdd problem
I'm creating a table for filling out working hours. Using style and javascript on the client side. Monday ------------------------ 00:00-01:00 | ------------------------ 01:00-02:00 | ------------------------ ... .. . ------------------------ 23:00-00:00 | ------------------------... -
DateAdd problem
Thanks :) I've now solved my problem the hard way... Using FormatDateTime to check the time and the date sepratly. /Core2max! -
DateAdd problem
What am I doing wrong? (WinXP, VB-engine:5.6) CODE: Option Explicit Dim tTime, tTest1, tTest2 tTime = CDate(Date & " 22:45:00") tTest1 = CDate(Date & " 23:00:00") tTest2 = CDate(Date & " 23:15:00") tTime = DateAdd("n",15,tTime) 'add 15min if tTime = tTest1 then msgbox "tTime is EQUAL to...
