2 Dateparts in 1 query

[SDS100UK]

Hi,

I have a query which selects yesterdays information for a report. Which is fine for most days of the week. But on a Monday it has to select the data not for yesterday but for Saturday AND Friday.

How can I say if Datepart("d",[date]) =2 then select -2 AND -3 days ago, otherwise just select -1 day ago.

Many thanks in advance

Steven

 

[tlbroadbent]

Use the IIf function.

WHERE table.datecol = IIf(Weekday(date())=2, dateadd("d",-2,date()), dateadd("d",-1,date()))
OR table.datecol = IIf(Weekday(date())=2, dateadd("d",-3,date()), dateadd("d",-1,date()))
Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.