Time calculations? 2

[MuraliKrishnaK]

Hi, Friends

How to do time calculations in VB such as adding / subtracting two or three hours from the current time. Searching for the given time or time range from the database, etc.,

Murali Krishna

 

[dpaulson]

Text1 = DateAdd("h", 3, Time) will add 3 hrs to the current time.


strsQL = &quot;SELECT * FROM MyTable WHERE MyDateField > #09/01/01# AND MyDateField < #10/01/01#&quot;

David Paulson

 

[jjames]

Just adding to David's response...

Text1 = DateAdd(&quot;h&quot;, 3, Time) will add 3 hrs to the current time.

indicating a negative number will subtract from the time...

Text1 = DateAdd(&quot;h&quot;, -3, Time) will subtract 3 hrs from the current time.