First day of the month

  • Thread starter Thread starter Angel_G
  • Start date Start date
A

Angel_G

Hi there.
I need to retrieve data in a query greater than or equal to11 months from
now() or date() but I need the criteria to default to the first day of the
month. I am trying
=DateAdd("m",-11,Date())
Click to expand...
But it defaults to current date 11 months ago11/6/03 but I need 11/1/03
(which is the first day of the month 11 months ago)
Can any one give me some ideas?
Thank you.
 
Hi there.
I need to retrieve data in a query greater than or equal to11 months from
now() or date() but I need the criteria to default to the first day of the
month. I am trying
But it defaults to current date 11 months ago11/6/03 but I need 11/1/03
(which is the first day of the month 11 months ago)
Can any one give me some ideas?
Thank you.
Click to expand...

11 months from today is 11 months in the future, but your DateAdd is
calling for 11 months in the past.
I'll assume you want from the previous 11 months.
 
Back
Top