AnsweredAssumed Answered

Calculation on mutiple records on two date/time stamp fields

Question asked by raney on Aug 30, 2018
Latest reply on Aug 31, 2018 by raney

Greetings all,

I'm still learning (and I still have a long way to go) FM and I've search for several days on how to do a calculation on two fields from different records. I've imported a .csv file and have performed a find set on the records of interest. For example,

 

Location1 StartTime 8/1/2018 7:55:10am

Location1 EndTime 8/1/2018 8:05:23am

Location2 StartTime8/1/2018 7:45:01am

Location2 EndTime8/1/2018 8:10:18am

Location3 StartTime8/1/2018 7:30:45am

Location3 EndTime8/1/2018 8:01:10am

and so on.

 

 

What I'm trying to do is calculate the elapsed time between the StartTime and EndTime for the records for location1, location 2, location 3, and for approximately 110 more different locations for each weekday in the month. I've looked at the script functions, but haven't figured out the way to write the script. I've looked at maybe using another table occurrence to get the results I'm looking for and as before, I haven't learned enough to make it work. I'm using FM 17.

 

Is there anyone who would be willing to point me in the right direction?

 

Thank you in advance,

R Aney

Outcomes