Using Dates with ADD-INTERVAL

MartinH

New Member
Im struggling to get ADD-INTERVAL to work. I get Syntax error. I'm not sure what is wrong with the syntax, could someone assist please?

Select Distinct "A"."MATDB"."MT-CODE",
"PUB"."BILLS"."CL-CODE",
"A"."MATDB"."DATE-OPENED",
"A"."CLIDB"."FULL-DERIVED-NAME",
"TELEPHONES2"."TEL-NUMBER" As "Email",
"A"."CLIDB"."A-ADDRESS1",
"A"."CLIDB"."A-ADDRESS2",
"A"."CLIDB"."A-ADDRESS3",
"A"."CLIDB"."A-ADDRESS4",
"A"."CLIDB"."A-ADDRESS5",
"A"."CLIDB"."A-POSTCODE",
"PUB"."FEETR"."NAME" As "NAME1"
From "PUB"."BILLS"
Inner Join "A"."MATDB" On "PUB"."BILLS"."MT-CODE" = "A"."MATDB"."MT-CODE"
Inner Join "A"."CLIDB" On "PUB"."BILLS"."CL-CODE" = "A"."CLIDB"."CL-CODE" And
"A"."MATDB"."CL-CODE" = "A"."CLIDB"."CL-CODE"
Inner Join "PUB"."FEETR" On "PUB"."FEETR"."FEE-EARNER" =
"A"."MATDB"."FEE-EARNER"
Inner Join "PUB"."CONTRELATIONS" On "A"."CLIDB"."CL-CODE" =
"PUB"."CONTRELATIONS"."REL-RECORD"
Inner Join "PUB"."CONTACTS" On "PUB"."CONTRELATIONS"."CON-REFERENCE" =
"PUB"."CONTACTS"."REFERENCE-CHAR"
Inner Join "PUB"."SECTORS" On "PUB"."CONTACTS"."CON-SECTOR" =
"PUB"."SECTORS"."SEC-CODE" And "PUB"."CONTACTS"."CON-SECTOR" =
"PUB"."SECTORS"."SEC-CODE"
Inner Join "PUB"."TELEPHONES" "TELEPHONES2"
On "PUB"."CONTACTS"."REFERENCE-CHAR" = "TELEPHONES2"."REFERENCE"
Where "TELEPHONES2"."TYPE" = 'CO' And "TELEPHONES2"."TEL-TYPE" = 4 And "A"."MATDB"."DATE-OPENED" <= ADD-INTERVAL(CURDATE(), -3, "months") And "A"."MATDB"."MOD-DATE" <= ADD-INTERVAL(CURDATE(), -1, "months")
 

LarryD

Active Member
ummm... did you try to Google for it? --- look at DATEADD but I have no idea if it works with the SQL 92 in OE.
 
Top