Query: Start of month to yesterday

[Nightspeace]

Hello Everyone,

I am currently having problems setting up a query that will pull records from the start of the month to the preivious day. In design veiw I am trying to set up a between statement that will update dymamically so I will not need to make a change manually each reporting period week.

ie:

Criteria: Between ( ) and Date()-1

Thanks for the Help

Mark

[missinglinq]

If you're looking for an expression that will return the first day of the current month, then

DateSerial(Year (Date()), Month(Date()), 1)

should do it.

Welcome to TheScripts!

Linq ;0)>