Date/time query from Access table ( last month)
- by chupeman
Hello,
I am using the query builder from Visual Studio 2008 to extract data from an Access mdb ( 2003), but I can't make it to work with a datetime field. When I run it with a third party query app I have works fine, but when I try to implement it into visual studio I can't do it.
What is the correct way to extract last month data?
This is what I have:
SELECT
[Datos].[ID], [Datos].[E-mail Address], [Datos].[ZIP/Postal Code], [Datos].[Store], [Datos].[date], [Datos].[gender], [Datos].[age]
FROM
[Datos]
WHERE
([Datos].[date] =<|Last month|>)
Any help is appreciated.
Thank you
