@williamcclay: "Dreamweaver 8.02, Access
I'm having trouble picking out the records where LastPmtDate is earlier than 
last month. Here's what throws a Data type Mismatch :
SELECT *
FROM Tablename WHERE varDateDiff > 1
Parameters -
Name: varDateDiff
Type: Date
Value:  DateDiff("M",Recordset1.Fields.Item("LastPmtDate").Value,Date)
Default value: Date() "
    @baxterremove: "I think it would be something like
SELECT *
FROM Tablename WHERE LastPmtDate  LIKE  'varDateDiff > 1'
if that's the field in the table
Dave
news:enpkb5$gik$<email_address>
<quote>
than"
    @williamcclay: "OK, getting closer, different error:
Microsoft VBScript runtime (0x800A01A8)
Object required: ''
/Login/Delinquency/report.asp, line 6
SELECT ColumnNames FROM Tablename
WHERE varDateDiff = 1
Parameters-
Name: varDateDiff
Type: Numeric
Value: DateDiff("M",Recordset1.Fields.Item("LastPmtDate").Value,Date)
Default Value: 1
4-Dim Recordset1__varDateDiff
5-Recordset1__varDateDiff = "1"
6-If (DateDiff("M",Recordset1.Fields.Item("LastPmtDate").Value,Date) <> "") 
Then
7- Recordset1__varDateDiff = 
DateDiff("M",Recordset1.Fields.Item("LastPmtDate").Value,Date)
8-End If"
    @design: "I would think that the problem is in your variable definition which should 
be something like
DateDiff("M",Recordset1.Fields.Item("LastPmtDate").Value,Date())
Paul Whitham
Certified Dreamweaver MX2004 Professional
Adobe Community Expert - Dreamweaver
Valleybiz Internet Design
<url>
"William Clay" <email_address> wrote in message 
news:enpkb5$gik$<email_address>
<quote>"
    @williamcclay: "<quote>
You are referring to the lack of the () after Date? It doesn't matter; 
either produces the exact same error. "
    @HIDElionstone: "If you're in the process of retrieving recordset1, what makes you think that 
values in recordset1 will exist to compare against?
SELECT ColumnNames FROM Tablename
WHERE DateDiff("m",LastPmtDate,Date()) > 1
No recordset parameters are necessary.
"William Clay" <email_address> wrote in message 
news:enpp0t$ldc$<email_address>
<quote>"
    @williamcclay: "Thanks for confirming what I had been suspecting... this example works 
perfectly, although Dreamweaver says there's a missing operator.
Thank you.
Bill
"Lionstone" <email_address> wrote in message 
news:eo09n4$ffj$<email_address>
<quote>"
    @williamcclay: "Whoops... THIS example works perfectly:
Select LastPmtDate from TableName
Where DateDiff(""M"",LastPmtDate,Date())=1
"William Clay" <email_address> wrote in message 
news:eo1n77$9u5$<email_address>
<quote>"
{'source': 'USENET', 'other_information': '{"reply_count": 7, "forum_name": "macromedia.dreamweaver.appdev.20141212.mbox"}', 'file': 'data/output/usenet-macromedia.dreamweaver.parquet'}