From: Michael Courter on
i need an example of how to code a time comparison.
i need to check to see if a value in a date/time column is greater than 10
minutes from the current time.
i appreciate your help.
thanks,
mcnewsxp


From: ralph on
On Fri, 8 Oct 2010 09:25:43 -0400, "Michael Courter"
<mcourter(a)mindspring.com> wrote:

>i need an example of how to code a time comparison.
>i need to check to see if a value in a date/time column is greater than 10
>minutes from the current time.
>i appreciate your help.
>thanks,
>mcnewsxp
>

Difftime()

-ralph
From: Bob Barrows on
Michael Courter wrote:
> i need an example of how to code a time comparison.
> i need to check to see if a value in a date/time column is greater
> than 10 minutes from the current time.
> i appreciate your help.
> thanks,
> mcnewsxp

What database? Type and version please. "Date/time" sounds like Jet...
Do you want to do this in a query? Or in your vbscript code?
--
HTH,
Bob Barrows


From: Bob Barrows on
ralph wrote:
> On Fri, 8 Oct 2010 09:25:43 -0400, "Michael Courter"
> <mcourter(a)mindspring.com> wrote:
>
>> i need an example of how to code a time comparison.
>> i need to check to see if a value in a date/time column is greater
>> than 10 minutes from the current time.
>> i appreciate your help.
>> thanks,
>> mcnewsxp
>>
>
> Difftime()
>
What's that?

--
HTH,
Bob Barrows


From: ralph on
On Fri, 8 Oct 2010 10:12:46 -0400, "Bob Barrows"
<reb01501(a)NOyahoo.SPAMcom> wrote:

>ralph wrote:
>> On Fri, 8 Oct 2010 09:25:43 -0400, "Michael Courter"
>> <mcourter(a)mindspring.com> wrote:
>>
>>> i need an example of how to code a time comparison.
>>> i need to check to see if a value in a date/time column is greater
>>> than 10 minutes from the current time.
>>> i appreciate your help.
>>> thanks,
>>> mcnewsxp
>>>
>>
>> Difftime()
>>
>What's that?

ha. Good question.

Wrong newsgroup.

-ralph
 |  Next  |  Last
Pages: 1 2
Prev: popup
Next: Excel window visible!