MM/DD/YY Formate Year Restricted SQL 1

[rmz8]

In the date format MM/DD/YY how can I make a SQL statement that only returns records with the year 01?

Thanks in advance.

Ryan ;-]

 

[Silvano]

try putting this in your query:

SELECT fieldName
FROM tableName
WHERE dateField LIKE '%01'

"%" is something like a wild card and this should return all the values that end with "01";

 

[rmz8]

Thanks sylvano!

Ryan ;-]