ReportPro User's Guide

Unknown

Purpose

To calculate the hours between two date/time values

Syntax

HoursBetween( <dDate1>, <cTime1>, <dDate2>, <cTime2>, <lWeekEnds> ) nNumber

Argument

<dDate1> The starting date

<cTime1> The starting time as character string formatted as "hh:mm:ss" (24 hour format)

<dDate2> The ending date

<cTime2> The ending time as character string formatted as "hh:mm:ss" (24 hour format)

<lWeekEnds> A logical indicating whether or not to count weekends

Returns

HoursBetween() returns the number of hours between <cTime1> on <dDate1> and <cTime2> on <dDate2>.  The first date/time value must be smaller of the two.

 

Table of contents

previous page start next page