Re: DateTimeDiff

2000-09-14 Thread Mark Adams
Something like this should work for you. Hello your #chktime# hour(s) late Good Luck! -Mark :o) - Original Message - From: Aidan Whitehall <[EMAIL PROTECTED]> To: CF-Talk (E-mail) <[EMAIL PROTECTED]> Sent: Thursday, September 14, 2000 7:44 AM Subject: DateTim

RE: DateTimeDiff

2000-09-14 Thread Aidan Whitehall
> Yes, it's DateDiff , use "h" for the datepart. > > DateDiff(datepart, date1, date2) > [snip] > i.. n -- Minute > j.. s -- Second Great - thank you. -- Aidan Whitehall <[EMAIL PROTECTED]> Netshopper UK Ltd Advanced Web Solutions & Services http://www.netshopperuk.com/ Telephone +44 (0

Re: DateTimeDiff

2000-09-14 Thread Mark Adams
Something like this should work for you. Hello your #chktime# hour(s) late Good Luck! -Mark :o) - Original Message - From: Aidan Whitehall <[EMAIL PROTECTED]> To: CF-Talk (E-mail) <[EMAIL PROTECTED]> Sent: Thursday, September 14, 2000 7:44 AM Subject:

Re: DateTimeDiff

2000-09-14 Thread JustinMacCarthy
Minute j.. s -- Second ~ Justin MacCarthy - Original Message - From: "Aidan Whitehall" <[EMAIL PROTECTED]> To: "CF-Talk (E-mail)" <[EMAIL PROTECTED]> Sent: Thursday, September 14, 2000 3:44 PM Subject: DateTimeDiff > Is there DateDiff function that allow

RE: DateTimeDiff

2000-09-14 Thread mherbene
DateDiff should work -you can specify intervals down to seconds. -Original Message- From: Aidan Whitehall [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 14, 2000 10:45 AM To: CF-Talk (E-mail) Subject: DateTimeDiff Is there DateDiff function that allows you to compare DateTime

DateTimeDiff

2000-09-14 Thread Aidan Whitehall
Is there DateDiff function that allows you to compare DateTime objects, not just Date Objects? I need to flag a record yellow if it's an hour overdue, orange if it's two hours overdue and red for anything more than that. Thanks -- Aidan Whitehall <[EMAIL PROTECTED]> Netshopper UK Ltd Advanced