Start of Month

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi

I have a query with a date of transfer field in it.

I would like to query this field based on criteria that would call up all
records from the beginning on the current month.

ie if today is 23/02/05 then I would like all records from and including
1/02/05 to and including today.

Is this possible??

Cheers

All help much appreciated.

Thanks
 
pjd said:
Hi

I have a query with a date of transfer field in it.

I would like to query this field based on criteria that would call up
all records from the beginning on the current month.

ie if today is 23/02/05 then I would like all records from and
including 1/02/05 to and including today.

Is this possible??

Cheers

All help much appreciated.

Thanks
Click to expand...


WHERE DateField BETWEEN DateSerial(Year(Date()), Month(Date()), 1) AND Date()
 
Back
Top