Date() functiom

  • Thread starter Thread starter Carl Johnman
  • Start date Start date
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
 
See if this will work.

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