D
Day of Month Number
Data Format Returned: D
DAY
displays the numeric day of the month for a
date field.
DaysInMonth(expD)
Returns the total number of days in the month for a date value. Respects leap years for February.
Returns: Character
Parameters
Variable | Status | Description |
---|---|---|
expD | Required | Specifies the date expression from which the number of days for the month is returned. |
DistCalc(expN1,expN2,expN3,expN4,expN5)
Data Format Returned: X
Calculates the distance in feet or miles between two latitude/longitude coordinates.
Parameters
Variable | Status | Description |
---|---|---|
expN1 | Required | Latitude of first coordinate. |
expN2 | Required | Longitude of first coordinate. |
expN3 | Required | Latitude of second coordinate. |
expN4 | Required | Longitude of second coordinate. |
expN5 | Optional | Dictates the value to return. If not passed or passed as zero (0), the value return is the distance between the two points in miles. If passed as 1, value returned is distance in feet. |
DistCalc(41.584025, -93.620128,40.861697,-79.898144)
returns the distance between the exact coordinates specified.
DistCalc(Lst.Latitude, Lst.Longitude, 40.861697,
-79.898144,1)
assumes the last two are the latitude and longitude
of the Fire Station. This
expression returns the distance from the fire station to each incident
in the Incident List by Alarm Time/Date
report. The
value is shown as feet. If
you remove the 1 at the end of the expression, the value displayed is miles.
Day/Month/Year
Data Format Returned: D
DMY
displays a date in Day Month Year format, such as 24 August 1996
.
DOW(expD)
Displays the numeric day of the week (1-7) for a date field. Sunday is 1, Monday is 2, and so forth.
Returns: Numeric
Arguments
Variable | Description |
---|---|
expD | Specifies the date expression from which the day number is returned. |
An example use for this function might be analysis of fire calls by day of week.
DtTm(expD,expC)
Data Format Returned: X
Converts a date value and a character time value into a single complete date/time data type value.
Parameters
Variable | Status | Description |
---|---|---|
expD | Required | Date value. |
expC | Required | Time value
in format HH:MM:SS .
|
DtTm(Lst.Alm_date,Lst.Alm_time)
returns
date and time in a single format, such as
12/02/98 09:00:00
.
DynaDate(expN1,expN2)
Data Format Returned: X
Returns a dynamic date value, such as fiscal year dates or other dates relative to current system date.
Parameters
Variable | Status | Description |
---|---|---|
expN1 | Required |
Numeric value for dynamic date element to return.
|
expN2 | Optional |
Numeric value that dictates whether the date returned represents the start or end of the requested dynamic date period. If not passed, start is assumed.
|
DynaDate(7,1)
returns the start of the
current calendar year 01/01/2002
.
DynaDate(7,2)
returns the end of the current
calendar year 12/31/2002
.