> 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;
}