Adding Issue

Hari · February 13, 2004, 3:26pm

Hi Everybody, I have defined fields like Employement Date,Probation Duration & Date of Confirmation.Now, i need to get the output as Date of Confirmation = Employement Date + Probation Duration where the data for Probation Duration will be entered in terms of months.Can i have a code for this? Thanks & Best regards Hari

wex · February 13, 2004, 3:35pm

Hari, Have a look at the CALCDATE statement. DateOfConfirmation := CALCDATE(ProbationDuration,EmployementDate);

Hari · February 13, 2004, 4:52pm

Hi Willy, Thank for this.But it throws error “The contents ‘0’ of CALCDATE parameter no.1 are invalid”. Best Regrards, Hari

wex · February 13, 2004, 5:09pm

Hi Hari, It’s best to define the field ‘ProbationDuration’ as a Dateformula. That way you can enter ‘1M’ for one month, ‘2M’ for two months and so on.

Hari · February 13, 2004, 5:23pm

Hi Willy, Still…the error says “You cannot base a date calculation on a undefined date”.

sfi · February 13, 2004, 6:18pm

Change the code to handle errors: if “Employment Date” > 0D then “Date Of Confirmation” := CALCDATE(“Probation Duration”,“Employement Date”);

Hari · February 13, 2004, 6:31pm

Thanks to both Willy & steen.Now its working fine. Best Regards Hari