comparing dates

beanbeanbean

Registered User.
Local time
Today, 00:53
Joined
Sep 17, 2008
Messages
124
hi is there any way to make a macro in which i am able to compare 3 dates ?


for example

i have a date called creation date. this date must be earlier than a date called shipping date. if that happens i can label it as approved.

is there a macro so that i can compare the dates quickly and thus not going through them 1 by 1 in the table ?
 
Use a query, not a macro?
 
No need to make a new thread... but a query is usually used for mass updates...
 

Users who are viewing this thread

Back
Top Bottom