• Home
 · 
• Databases/Data Access/DAO/ADO
 · 
• The Code is Used to Find Records from the Database that are Greater than or Less than The Date Give

The Code is Used to Find Records from the Database that are Greater than or Less than The Date Give

The Code is Used to Find Records from the Database that are Greater than or Less than The Date Given(Current Date) In either Cases Contact me.

API Declarations



2.Liqua is the Name of the Table and The Sdate is the Field of the Table The Day(),Month() and Year() are the Functions that extract Day,Month and Year from the Date.



Rate The Code is Used to Find Records from the Database that are Greater than or Less than The Date Give

• 1
• 2
• 3
• 4
• 5

(1(1 Vote))

Set Rs = Db.OpenRecordset("select * from Memo where Cdate(Date)>= '" & Date & "'")

'Finds all Records Equal to the Current Date
Set RsLiqua = Db.OpenRecordset("select * from liqua where day(Sdate)='" & Day(Date) & "' and month(Sdate)='" & Month(Date) & "' and year(Sdate)='" & Year(Date) & "'")