SQL Statements and dates

[Guest_imported]

Hi

I need to execute some SQL statements that compare dates. Firstly I need to return all records that are 2 months older than a date stored as one of the fields.

Secondly need to return all reocrds that are older than the same date field stored as one of the fields.

Where can I find out information on using dates with SQL statements???

TIA
Paul.

 

[culshaja]

Within the WHERE field you would use something like the following code:

SELECT tblA.* FROM tblA
 WHERE tblA.DateField > (SELECT DateAdd("mm",tblB.dateField, -2) As DateCheck FROM tblB WHERE id = 2)

A good place to look is SQL Server Books Online. If you do not have these installed then look at the following:

http://msdn.microsoft.com/library/default.asp?URL=/library/psdk/sql/8_gs_00.htm

James James Culshaw
jculshaw@active-data-solutions.co.uk

http://www.active-data-solutions.co.uk

http://www.brainbench.com/transcript.jsp?pid=193305