Date Expression for a Query

[CassandraB]

I would basically like to print a daily report of activity with the report always beginning on Monday.

For example:
If today is Monday, Mondays report would have Mondays activity
If today is Tues, Tues report would have Mon & Tues
If today is Wed, Wed report would have Mon,Tue & Wed
If today is Thur, Thur report would have Mon-Thurs
If today is Frid, Frid report would have Mon-Frid activities

How would I write the expression for this? I'd appreciate anybodys help. Thanks a bunch!

 

[bjackson]

Try this
StartDate: IIf(Weekday(Date) = 2, Date, IIf(Weekday(Date) = 3, DateAdd("d", -1, Date), IIf(Weekday(Date) = 4, DateAdd("d", -2, Date), IIf(Weekday(Date) = 5, DateAdd("d", -3, Date), IIf(Weekday(Date) = 6, DateAdd("d", -4, Date), 5)))))

That would give you the start date for your print out and your
finish date would=Date()

It might work