I am trying to calculate how many days have passed since the previous event occured. I am using the peek function (works succesfully), but for some reason when I try and do calculations with my data it does not give me what I expect (amount of days gone by). Below is the sample Load script. Anyone have any idea what I'm doing wrong?
Try date#() instead of date(). Date() is a formatting function. Date# converts a string into a date. Although as long as your dates match your default date format, I wouldn't think you'd need either function, because the fields should already be dates, I'd think. In any case, I suspect you're having formatting problems. One clue is whether F2 and F3 are left or right justified. If left, they probably didn't get interpreted as dates.
