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
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
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
) [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
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)
) [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
6 matches
Mail list logo