Search results for query: *

Thanks very Much, that seems to have sorted it i think. I'll you know it it's not :)

Yes, the same rule applies. Its not checking todays date, its taking the date from the Stage4date and checking to see if they were at stage4date before the 25th of last month. the actual date the report is made on doesnt affect whether the stage4date is before the 25th of last month.

Yes today it has to be all records that are less than 2/25/2006 It looks to see if the client has paid, and if that is false then it does a check to see if the client was at stage4 (which will be different for each client), before the 25th of the previous month. If the client was at stage4...

Hi, i am a virtual beginner at MSSQL and have had to learn on the job as it were, I'm currently stuck on a report. This report checks a date to see whether that date was before the 25th of the previous month. The previous guy who did the query was shocking and now ive been left with a mess and i...