I didn't mean to upset anyone.

I was just trying to understand why it didn't work, now I do understand.

I really appreciate you guys taking the time to help.

Good karma to...

is this wrong?

original way:

WHERE

isnull(datediff(dd,ld.delq_dt,getdate()),0) < 30

this:

WHERE

isnull(datediff(dd,ld.delq_dt,'2009-09-30'),0) < 30

I'm not getting the same results

could it have something to do with not using the 'isnull' ?

thanks so much for helping me out...

I need the month of september

So...if I want to only see last months (september) then I would change it to

WHERE ld.delq_dt < dateadd(mm, datediff(mm, 0, '2009-09-30'), 0)

or

WHERE ld.delq_dt < dateadd(mm, datediff(mm, 0, '2009-30-09'), 0)

sorry lutz missed your edit

trying now..

lutz

I get an

An expression of non-boolean type specified in a context where a condition is expected, near ';'.

thanks ken..but I don't think that's right...I get zero rows back (I know there are records)

I think I figured it out, thanks guys.

thanks everyone..

shouldn't I be able to simply add 'GETDATE()' to the default value or binding of the table, so it inserts the current date when a record gets inserted?

Lynn

if I add that in the default value or binding..it doesn't auto fill it for me when I insert a record into that table

no I don't know how to do that can you explain?

Thanks for answering..

I think the issue is I'm trying to insert 'empty' into a datetime column...

Should I have the vender change the empty's to 'NULL'?

Makes sense thanks!