AppendDateRangeLocalToUtc Method

Member of ISSqlWhereBuilder
Append a UTC Date Range to the SQL Where clause. The 'dateRange' parameter is in Local time. The dates are converted to UTC dates before the date range is appended to the SQL Where clause.

<para> If the dateRange parameter contains no values then nothing will be appended. </para> <para> WARNING: The supplied dates in the dateRange parameter will be converted from local to UTC regardless of the date's DateTimeKind, e.g., even if the DateTimeKind is 'Utc', it will still be adjusted to universal time as if it were a local date. </para>

Syntax

ISSqlWhereBuilder.AppendDateRangeLocalToUtc(fieldName, dateRange, [includeNullIfNoToDate])

Parameters

NameTypeOptionalByRefDescription
fieldName String The compare field name.
dateRange ISDateRange The Date Range in Local time.
includeNullIfNoToDate Boolean Optional Indicates whether to allow the field to be Null if a From date is included but no To date. If omitted, a value of False is assumed.
Member of:
ISSqlWhereBuilder
Namespace:
Intersoft.ISSupport6
Assembly:
ISSupport6, Version=6.0.3
Target Framework:
.NET 9.0