Date/time query from Access table ( last month)

Posted by chupeman on Stack Overflow See other posts from Stack Overflow or by chupeman
Published on 2010-01-05T23:32:25Z Indexed on 2010/05/09 11:08 UTC
Read the original article Hit count: 213

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

© Stack Overflow or respective owner

Related posts about visual-studio-2008

Related posts about query-builder