Calendar Problem

srinivas.chittemsrinivas.chittem Member Posts: 142
Hai,

Here i have a small problem regarding the calemdar..........

In my company i am calculating employee experience interms years,months,days with work date...

I have three fields in emp...Card
1.years
2.months
3.days
Is there any navision functionality to calculate Employee experience automatically by calculating JOINING DATE with TODAY........

bye
sri
Regards,
srinivas
"Delighting Customers.... Through Delivery Excellence" .

Comments

  • Timo_LässerTimo_Lässer Member Posts: 481
    Therefore you need two steps:
    1. Create a date
    2. Calculate the number of days until TODAY (or WORKDATE)

    You can write these two steps in one line of code:
    NoOfDays := WORKDATE - DMY2DATE(YourDayField,YourMonthField,YourYearField);
    
    Timo Lässer
    Microsoft Dynamics NAV Developer since 1997
    MSDynamics.de - German Microsoft Dynamics Community - member of [clip]
Sign In or Register to comment.