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

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

Re: DateTimeDiff

2000-09-14 Thread JustinMacCarthy
te 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 allows you to compare Da

Re: DateTimeDiff

2000-09-14 Thread Mark Adams
) [EMAIL PROTECTED] Sent: Thursday, September 14, 2000 7:44 AM Subject: DateTimeDiff 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 any

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 (01744)

Re: DateTimeDiff

2000-09-14 Thread Mark Adams
) [EMAIL PROTECTED] Sent: Thursday, September 14, 2000 7:44 AM Subject: DateTimeDiff 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 th