Function isn't available in expressions - Urgent Help

  • Thread starter Thread starter Ian
  • Start date Start date
I

Ian

Hi,

Thanks for your help in advance.

I have had a query running for a few years with no
problems.

All of a sudden I get "Function is not available" the
line in question is as follows:-

The date field is formatted as "dd/mm/yy" for a table
called deliveries the query item is calculated as follows:-


Wed: IIf(Format([Date],"w")>4,DateAdd("d",11-(Format
([Date],"w")),[date]),DateAdd("d",4-(Format([Date],"w")),
[date]))

Why all of a sudden did it go wrong?

What do I do to fix it.

I use this statement quite a lot so if I could get it to
work without alteration it would be very helpfull.

Thanks again

Ian

Email address has been amended to stop spamming as please
post a reply rather than sending me an email
 
Back
Top