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!

This is for ad-hoc reporting and is one big 'flat table'.

So, I never know what fields they could pick, they could pick any or all of the 400 columns.

Long story...

I as really hoping there was a user guide already out there somewhere...