Calculating Fields

[Waldin]

Hi All

this one is abit of a challenge

i have a field named RepairStartdate (date format is short date eg: 00/00/000)

2nd field is named WorkingRepairDays (Format is Interger eg: 10)

3rd field is my desired calculated Field Named EstimatedRepairEndDate (Format is short date)

now i want the RepairStartdate and the WorkingRepairDate to calculate the Estimated Repair end date.

how do i achieve this, keeping in mind that the two fields has different date formats, and the desired calculate field's (Estimated Repair End Date) Date Format must be short date 00/00/0000

is there any1 who could prove my colleuges wrong by helping me achieve this.

 

[pr2-eugin]

What is the Formula for calculating the Estimated Repair End Date? Is it just adding the WorkingRepairDates with the RepairStartDate? If so you can use the DateAdd() to get the result.. the general format is..

DateAdd("whatToAdd", NumberToAdd, #whatToAddWith#)

So in your case it would be..

Dim addNum As Double
Dim addVal As Date
addNum = Me.WorkingRepairDays
addVal = Me.RepairStartdate
DateAdd("d", addNum, addVal)

 

[Waldin]

Magnificent.
Thanks A Million.

 

[pr2-eugin]

You are welcome..