G
Guest
Dear Access Gurus,
Please help. I have a database in which I ask the user to put in a date and
then the query should pull all the dates for a one year previous period.
However, all the dates do not show up even though they are in the table. For
example, if the user enters 01/31/07 then 01/31/06 doesn't show up. My field
is a date field. Below is my query.
Between [enter date in format 01/01/07] And DateAdd("m",-12,Date())
Thank you!
Please help. I have a database in which I ask the user to put in a date and
then the query should pull all the dates for a one year previous period.
However, all the dates do not show up even though they are in the table. For
example, if the user enters 01/31/07 then 01/31/06 doesn't show up. My field
is a date field. Below is my query.
Between [enter date in format 01/01/07] And DateAdd("m",-12,Date())
Thank you!