Home ›
ASP.NET Forums » Data Access » Access Databases and AccessDataSource Control » How to fetch Dates

How to fetch Dates

Last post 06-30-2008 2:22 AM by PassHours. 1 replies.

Sort Posts:

  • How to fetch Dates

    06-30-2008, 2:17 AM
    • Loading...
    • divseep
    • Joined on 06-30-2008, 5:59 AM
    • Posts 11

    How to fetch Dates from Access database using between clause?

  • Re: How to fetch Dates

    06-30-2008, 2:22 AM
    Answer
    • Loading...
    • PassHours
    • Joined on 03-06-2006, 5:50 AM
    • India
    • Posts 289

    In Access you need to provide # sign while dealing with dates like the example below

    Select *from [TableName] where [DateField] between #FirstDate# and #SecondDate# 

    Hope that helps Yes 

    Techie (.Net Knowledge at its Best)
Page 1 of 1 (2 items)
RSS Available

Advertise on ASP.NET

About this Site

Microsoft Communities
Page view counter