Calculate Date based on Period.

Huvan

Hi
I need to calcualte compensation based on the date specified and i have a setup table where i will give settign calcualtion for compensation (Like if a person has been set a option of week ( Compensation calcualted based on weeks). and period is 2( 2 Week means that the compensation is calculated per 2 two weeks.)

I have a table where in i create records for all the calcualted Compensation so that its not Imported again.
My problem is how to calculate the date (for every two weeks if i give a filter of date 010510 to 31 05 10).
(*,)

I should calcualte it for all the resource that are applicable for this time period, each person have a different Calculation (week, quarter,month).

Regards
Huvan ]

einsTeIn.NET

Is it a question? Wrong forum?

If I understand correctly you want to calculate a date that is two weeks ahead from a given date. Take a look at the function CALCDATE.

NewDate := CALCDATE('<+2W>',GivenDate); // 2 weeks
NewDate := CALCDATE('<+1M>',GivenDate); // 1 month
NewDate := CALCDATE('<+1Q>',GivenDate); // 1 quarter

Huvan

Hi,

I too know how to work on calcdates.
But my question is
how to calculte in a loop for a given set of date(say for 030510..300510).
which have 4 weeks the user has an option of 2 weeks(every two weeks i have to calcualte compensation this should be calculted only twice).

einsTeIn.NET

If you know about CALCDATE you should also know that the Expression of CALCADATE is a string. You could substitute it by STRSUBSTNO.

NewDate := CALCDATE(STRSUBSTNO('<+%1W>',NoOfWeeks),GivenDate);

And you can subtract GETRANGEMAX from GETRANGEMIN of your range to get the number of days between that two dates. Divide it by the length of your period so that you know how many iterations your loop needs.

kriki

[Topic moved from 'NAV Tips & Tricks' forum to 'NAV/Navision Classic Client' forum]