Query previous weekday

[skwilliams]

I need a query to pull the previous weekday. Normally I'd just do =Date()-1 but this won't work on a Monday.

Thanks.

 

[Brianwarnock]

You will need to use the Weekday function to test for the day of the week

Brian

 

[skwilliams]

Can you give me an example?

 

[Brianwarnock]

The function is in help, maybe VBA help, but weekday(date) I think the syntax is gives the day of the week, but you should read the help.

Brian

 

[skwilliams]

I tried weekday but the syntax must be wrong. I'll just need to search around more.

Thanks for the help.

 

[Brianwarnock]

Here is the start of the help

Weekday Function


Returns a Variant (Integer) containing a whole number representing the day of the week.

Syntax

Weekday(date, [firstdayofweek])

The Weekday function syntax has these named arguments:

Part Description
date Required. Variant, numeric expression, string expression, or any combination, that can represent a date. If date contains Null, Null is returned.
firstdayofweek Optional. A constant that specifies the first day of the week. If not specified, vbSunday is assumed.

 

[raskew]

Hi -

Where Sunday =1 thru Saturday = 7

? date()
1/18/2010

? date() - IIf(WeekDay(date()) < 3, 1 + WeekDay(date()), 1)
1/15/2010

HTH - Bob