Variable Syntax in IF..THEN 1

[Bass71]

Hello,

I'm trying to find the correct sytnax for the following...
dim j
j = InputBox ("Enter Logoff Time in Military Format")

If SysTime > "# & j & #" Then...<<this doesn't and many other variations do not work>>

However, if I write:
If SysTime > #18:30# Then...<<this works>>

How can I pass j into the If Then statement?

Thank you..........RO

 

[PHV]

A starting point:
If IsDate(j) And SysTime > TimeValue(j) Then

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[Bass71]

Well there's no problem with the first part of the statement: If SysTime > 'SysTime has been dimmed

I need to get the exact syntax for the condition after the > which is #j# >>This I cannot figure out...

 

[PHV]

Seems you don't know what is the goal of the TimeValue function:

http://msdn.microsoft.com/library/en-us/script56/html/f97ecda8-816a-480a-ae88-3e30d96a98f6.asp

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[Bass71]

Ahaa!!.........muchas gracias!

 

[barny2006]

date and time literals must be imbeded inside #'s.
like #18:30# or #8/02/2006#