SQL greater than Date

[Raanan]

Hi, Im hoping you can help a little..

Im trying to pull data from an Access database based on "date completed" being this year, using SQL.

Im using:
Select ....
FROM ....
WHERE [Date Completed] > '20150101'

however Im getting data mismatch.

Ive checked the Access and the date completed file is in the format Date/Time.

Ive tried different variations but cant get this to work. Any ideas?

 

[Fazza]

WHERE [Date Completed] >= #2015/01/01#

WHERE [Date Completed] >= DateSerial(2015,1,1)

WHERE CLng([Date Completed]) >= CLng(DateSerial(2105,1,1))

 

[HiTechCoach]

It will depend a lot on the data type for the field [Date Completed]. If the datatype is date/Time then Fazza's suggestions will work.

Note: The suggestion will only work until for the current year and not past years.

I am suuing the field is a date/time data type.

If you want to be able to run this for any year then you could use:

 WHERE Year([Date Completed]) = ([enter4 digit  year])

for the current year

WHERE (Year([Date Completed]) = Year(Date()) )

Note: using Year() also remove any time (Like using Clng() )