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

gmsfzllc
gmsfzllc Member Posts: 12
in NAV Three Tier
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



4.png 98.3K
3.png 54.1K
2.png 35.4K
1.png 10.3K

Answers

  • hawkeye
    hawkeye Member Posts: 51
    Something like this?

    FromDate := DMY2DATE(1,DATE2DMY(RefDate,2),DATE2DMY(RefDate,3));
    ToDate := Calcdate('1M-1D',FromDate);
  • ondercin
    ondercin Member Posts: 15
    You are inserting a record "EmployeeAttendance" and always using AttendanceDate which I am guessing is your "Date From"


  • Slawek_Guzek
    Slawek_Guzek Member Posts: 1,692 
    MonthStart := CALCDATE('<-CM>', SomeDate);
MonthEnd := CALCDATE('<CM>', SomeDate);
    Slawek Guzek - www.yitron.co.uk
    Business Central, MS SQL Server, Wherescape RED;

Categories