Date() functiom

C

Carl Johnman

I am currently using in a query:
Warning: Switch([RecievedDate]=Date()+ 1,"Warning: The
deadline is one day past due!")
and continued to 3 days but I ran into a problem: How can
I sum up all dates 4 or more days late in one summary
statement?

Thanks for any help,
Carl
 
W

Wayne Morgan

See if this will work.

Switch(......, [RecievedDate]>=Date()+ 4,"Warning: The deadline is four or
more days past due!")
 
Top