#2:00:00 AM# Format 
Author Message
 #2:00:00 AM# Format

Hello all, Does anyone know what format is this?...

I am adding two hours two hours to the current time by doing this...

temp = Now + #2:00:00 AM#

now it works fine...but I want the user to be able to enter how many
hours to enter....So I enabled them to enter it in a textbox...But
when I do this:

temp = Now + Textbox1.Text

it doesn't work..it gives me a mismatch error....Does anyone know the
format of this time?...and how to make this code work?

thank you in advance

Jazz



Sat, 07 Feb 2004 04:13:53 GMT  
 #2:00:00 AM# Format
Jazz

Look up the DateAdd() function in help

regards

Ian

** invalid email address, change dk to denmark

homepage http://www.kingsoft-denmark.com/
Tips & Tricks page http://tips.kingsoft-denmark.com/


Quote:
> Hello all, Does anyone know what format is this?...

> I am adding two hours two hours to the current time by doing this...

> temp = Now + #2:00:00 AM#

> now it works fine...but I want the user to be able to enter how many
> hours to enter....So I enabled them to enter it in a textbox...But
> when I do this:

> temp = Now + Textbox1.Text

> it doesn't work..it gives me a mismatch error....Does anyone know the
> format of this time?...and how to make this code work?

> thank you in advance

> Jazz



Sat, 07 Feb 2004 04:27:48 GMT  
 #2:00:00 AM# Format
Try this:

    Temp = DateAdd("h", Val(Text1.Text), Now())

Jennifer



Sat, 07 Feb 2004 23:40:12 GMT  
 
 [ 3 post ] 

 Relevant Pages 

1. MAC Address = 00 00 00 00 00 ????

2. #2:00:00 AM#

3. Returned MAC-Adress is only 00 00 00 00 00 ????

4. Date of 00/00/96

5. find convert input/ouput file QB2.00->VB3.00

6. Need comdlg32.dep ver 6.00.8169 and comctl32.dep ver 6.00.8022

7. Upgrading from comctl32 5.00.3714 to 5.00.3828

8. Problems after Upgrade 4.00.3711.08 to 4.00.5303.01

9. Windows CE .NET Online Chat - July 26th 12:00-13:00 PST (20:00 BST, 19:00 GMT)

10. ADO/SQL Server: datetime column appears to be "1901-1-1 00:00:00" after insertion

11. 00 format

12. ANN: Windows CE .NET Online Chat - July 24th 12:00-13:00 PST (20:00 BST, 19:00 GMT)

 

 
Powered by phpBB® Forum Software