> The expression that will get all records for the current month would be; > > MONTH(Date_field) = MONTH(DATE()) I've done my two hours debugging for a thing like that. It includes all Septemb ers regardless of the year, and in the testing phase you usually have only one year 's data, or less. I prefer setting two vars like this, just to make sure:

        StartDate_ld=date()-day(date())+1
        EndDate_ld=GoMonth(StartDate_ld,1)-1
        select .... where date_field between StartDate_ld and EndDate_ld

.Signature { margin-top: 12px; color: #666666; } .Signature a { color: #666666; }