Navigation:  Module 1 - Energy Accounting > Accounts & Invoices Tab > User Defined Components > Functions >

DateRange

Previous page Next page
  rev. 2011-02-09        

DateRange

Description:

Returns a span of time with a specific start date and end date.

Syntax:

DateRange(startDate, endDate)

Type:

DateRange

Arguments:

Argument

Type

Description

startDate

DateTime

The starting date/time

endDate

DateTime

The ending date/time

Returns:

A DateRange which represents the specified span of time identified by the startDate and endDate.

Examples:

To create a date range starting from January 20 2009 to June 15 2009

Expression

Result

DateRange(CreateDate(2009,1,20), CreateDate(2009,6,15))

1/20/2009 12:00:00 AM - 6/15/2009 12:00:00 AM



S2_DateRange_Function         ©2014 Managing Energy Inc.