Is it possible to scan a database, for a field that match the following statement??:
Month(field) = Month(date) and Day(field) = Day(Date)
(I want the program to get the fields that match with the current day)
Printable View
Is it possible to scan a database, for a field that match the following statement??:
Month(field) = Month(date) and Day(field) = Day(Date)
(I want the program to get the fields that match with the current day)
What DBMS are you using?
DAO 3.6
Access, aka Jet.
I've never done it but you should be able to use the format command.
For example:
select * from table where Format([HireDate],"m")=12 and
Format([HireDate],"d")=25
should get a hiredate of 12/25