Hi Nitin Verma ,
trigger OnAfterGetRecord()
begin
// clear(Month);
Clear(Year);
GetNameOfMonthFromDate("Posting Date", Year, Month);
end;
}
}
procedure GetNameOfMonthFromDate(GetDate: Date; var year: Integer; var month: Text): Text[10]
var
ModValue: Decimal;
NameOfMonth: Text[10];
GetMonth: Integer;
GetYear: Integer;
begin
GetMonth := Date2DMY(GetDate, 2); //Return Month value form Date
GetYear := Date2DMY(GetDate, 3);
Case GetMonth of
1:
NameOfMonth := 'JAN';
2:
NameOfMonth := 'FEB';
3:
NameOfMonth := 'MAR';
4:
NameOfMonth := 'APR';
5:
NameOfMonth := 'MAY';
6:
NameOfMonth := 'JUN';
7:
NameOfMonth := 'JUL';
8:
NameOfMonth := 'AUG';
9:
NameOfMonth := 'SEP';
10:
NameOfMonth := 'OCT';
11:
NameOfMonth := 'NOV';
12:
NameOfMonth := 'DEC';
End;
month := NameOfMonth;
year := GetYear;
end;
var
Year: Integer;
I don't have posting date on matrix reports. I have sent in GetNameOfMonthFromDate("Posting Date", Year, Month) and extracted months.
Do you have any idea?
