Thank you all for your time and suggestions.

In the end I didn't want to go this far so I used your suggestions and simplified it to just return values as...

Craig,

Thank you for your time. I do not understand your "AS drv" ?

And in response to the second post, I do want all records for that code where one of...

Okay, well thank you for your advise.

This was just an example, I put in the names for some clarity, I guess it didn't work.

I was really just interested in advise...

The expressions I have tried work great for today's (last day of previous month) I cannot get it to evaluate the date of the first invoice and find the last...

Hi again,

This objective is a work-around for a supplimental task for an application-driven db. That said I came up with a solution that is less-than elegant to be sure.

I added...

Yes, I see what you are both saying now: I will try it with the conversion as well.

This should be much better, thank you for help.

Thank you, It returns records with yesterdays date in that field.

I have tried

...and chsdat = DATEADD(d, -1, GETDATE())

This does not seem to work.