E

Earlier(expD1,expC1,expD2,expC2)

Data Format Returned: X

Determines if the combined date/time value of a date and time are chronologically earlier than the combined date/time value of a comparison date and time.

Parameters

Variable Status Description
expD1 Required Date value to compare against.
expC1 Required Time value to compare against in the format HH:MM:SS.
expD2 Required Date to compare.
expC2 Required Time value to compare in the format HH:MM:SS.

Elapsed(expD1,expC1,expD2,expC2,expN)

Data Format Returned: X

Returns the amount of time elapsed between two date/time values as either a numeric value representing elapsed hours, minutes or seconds, or a formatted time string (HH:MM:SS).

Parameters

Variable Status Description
expD1 Required Beginning date.
expC1 Required Beginning time in the format HH:MM:SS.
expD2 Optional Ending date. If not passed, current system date is assumed.
expC2 Optional Ending time in the format HH:MM:SS. If not passed, current system time is assumed.
expN Optional

Numeric value representing value to return.

  • 1 = Minutes,
  • 2 = Seconds,
  • 3 = Hours,
  • 4 = Formatted Time String (HH:MM:SS).

If not passed, Hours is assumed.

Elapsed(Average_resp.Alm_date,
Average_resp.Alm_time,Average_resp.Arv_date,Average_resp.Arv_time,1) returns the difference, in time format (hh:mm:ss), of arrival time minus alarm time.

This FH function lists email addresses for a specified record.

EmailList(cEmailTable,cID)

Data Format Returned: Character

Use to gather email addresses for a record when the record's ID is available.

Parameters

Variable Description
cEmailTable The name of the table the email is in, such as stf_eml.
cID The key id for the record.

To gather staff email from a results table that includes Staff ID, EmailList () could be used to return email addresses for staff.

For example, on a printed report form that uses the StaffList query, EmailList('STF_EML',StaffList.staff_id) would return email addresses for staff with email addresses.

EmptyTime(expC)

Data Format Returned: X

Determines if the time value passed is empty. Ignores colons in the time value.

Parameters

Variable Status Description
expC Required Time value to analyze.

EMSCompletionStatus(expC)

Data Format Returned: R

Returns a verbose description of the completion status of a EMS/Search & Rescue incident report.

Parameters

Variable Status Description
expC Required

ID of the incident to return completion status for.

Note: This is an incident ID and not an incident number.