I am having great difficulty in converting a Panorama 6 database into Panorama X. The original import of 13,000 records (with 17 fields) seemed to go well, but formulas that always worked fine in 6 are not working in X. The main formula is as follows:

Field "StrtTimeConv"

formulafill time(StartTime)

Field «End Time Conv»

formulafill time(EndTime)

Field "Time Diff"

formulafill timedifference(StrtTimeConv,«End Time Conv»)

Field "Time Diff text"

formulafill timepattern(«Time Diff»,“hh:mm”)

Field «Decimal time»

formulafill «Time Diff»/3600

Field Case

The purpose is to determine a decimal number that represents the difference (in hours) of a starting time and an ending time. In the formula, I first convert the starting time into seconds. Next I convert the ending time into seconds. Next, I subtract start time (in seconds) from end time (in seconds). Next, I express the time difference as hh:mm. Finally, I divide the time difference in seconds by 3600, to achieve my goal of a decimal respresentation of the time difference.

This should be simple, but when I run the formula, I immediately get an error message - time( function: illegal time “”. I cannot understand the problem, as start and end time are always normal times (such as 4:25 PM). I have studied the formulas in Panorama 6 and X and the only difference I see is that the previous FormulaFill is now written with no capitals (formulafill). I made that change, but there is no difference.

What am I missing?