time compare
in [VbScript]
|
Prev: popup
Next: Excel window visible!
From: Michael Courter on 8 Oct 2010 09:25 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 8 Oct 2010 10:07 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 8 Oct 2010 10:12 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 8 Oct 2010 10:12 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 8 Oct 2010 10:23
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 |