by Syed Zulfiqar Ali Hussain Rizvi (2 Submissions)
Category: Databases/Data Access/DAO/ADO
Compatability: Visual Basic 5.0
Difficulty: Unknown Difficulty
Originally Published: Thu 7th February 2002
Date Added: Mon 8th February 2021
Rating: 
(1 Votes)
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.
VBcoders
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) & "'")
No comments have been posted about The Code is Used to Find Records from the Database that are Greater than or Less than The Date Give. Why not be the first to post a comment about The Code is Used to Find Records from the Database that are Greater than or Less than The Date Give.
