How can I do From Date to To Date for generate the attendance for one month?

gmsfzllc

Dear All,

I want to generate attendance date for one month for every employee but I have done for one day for every employee.

How can I do From Date to To Date for generate the attendance for one month?

For your reference below are screenshots.

Thanks,
AM

hawkeye

Something like this?

FromDate := DMY2DATE(1,DATE2DMY(RefDate,2),DATE2DMY(RefDate,3));
ToDate := Calcdate('1M-1D',FromDate);

ondercin

You are inserting a record "EmployeeAttendance" and always using AttendanceDate which I am guessing is your "Date From"

Slawek_Guzek

MonthStart := CALCDATE('<-CM>', SomeDate);
MonthEnd := CALCDATE('<CM>', SomeDate);