weekdays versus weekend

[webisti]

hi
I do have a report that will show me the client orders for that day. ex in the query that builds the Today`s orders table the criteria in the order_date is easy : Date()
How can I make it possivble that when the check is done on monday it also checks all client orders since Friday.

regards

Webisti

[June7]

Maybe:

BETWEEN IIf(Weekday(Date())=2,Date()-2, Date()) AND Date()

[webisti]

Hi sorry for returing again but the formula will show me all mondays.. I want just the orders since last friday if today is monday.. otherwise date()
Is there a ay to o that?

[June7]

You want only Sat and Sun records?
Try:
BETWEEN IIf(Weekday(Date())=2,Date()-2, Date()) AND Date()-IIf(Weekday(Date())=2,1,0)

[webisti]

Hi June
Actually I want on monday to include all orders since friday (including Sat, Sun), the point is that is that by applying the Between formula it shows me all mondays and all fridays (the entire last two months) But what I want is that if today is monday I want the order since last friday only, not the onews before. Just since last friday until monday, otherwise in other days just the day().
Any ideas?

Thanks

[June7]

I don't see how that expression could return two months of records.

[webisti]

I am also thinking about it but may be will try again to rebuild the query step by step...