SoftadminUtil.Date_Range

 Show all Hide all

Returns all dates between two dates.

Type: Table-valued function
Area of use: General use

Parameters:

@FromDate mandatory datetime
The first date in the list.

The time part is ignored.
@ToDate mandatory datetime
The last date in the list.

The time part is ignored.

Resultsets:

Resultset: Dates

List of dates.
Repeat mode: repeated exactly once
Row count: zero or more rows

Columns:

DateDay mandatory date
A date.