Date formula problem

[mattfox]

This is a formula that I created to calculate a date. The problem that I have now is that I do not want this formula to output a date that falls on Saturday or Sunday. Can anyone help?

=IIf(((IsNull([Forms]![Imports2]![Pick-up Date])) And ((Date()-[Forms]![Imports2]![Date Arrived]-11)<1)),(Date()-[Forms]![Imports2]![Date Arrived]-11),([Forms]![Imports2]![Pick-up Date]-[Forms]![Imports2]![Date Arrived]-11))

Thanks,

Matt

 

[THoey]

Matt,

Don't have time to try and figure out what your query is doing, but look at the Weekday function. You can test for a return of 1 or 7 and alter it as you like.

Hope that helps... Terry M. Hoey