Skip to content

DateTimeToString - cDRReportHelper

Methods

Method Type

Function

Return Type

String

Arguments

Argument Description
dtIn Datetime value to be formatted as string.

Description

This function can be used to format a DateTime variable as a string in the YYYY-MM-DD HH:MM:SS format often used by SQL servers.

Sample

Object oOrderListReportSelect Is A cWebView
    Set psCaption to "OrderList Report Selections"
    Set pbShowCaption to False
    Set peWebViewStyle to wvsDrillDown

    Object oOrderHea_DD is a OrderHea_DataDictionary
    End_Object

    Object oReportHelper is a cDRReportHelper
    End_Object

    Procedure OnGetNavigateForwardData tWebNavigateData ByRef NavigateData
        String sOrderHeaOrderDateTime

        WebGet psValue of oOrderHeaOrderDateTime to sOrderHeaOrderDateTime
        If (Not (IsNullDateTime (sOrderHeaOrderDateTime))) Begin
            Get DateTimeToString of oReportHelper sOrderHeaOrderDateTime to sOrderHeaOrderDateTime
            Get NamedValueAdd NavigateData.NamedValues "OrderHeaOrderDateTime" sOrderHeaOrderDateTime to NavigateData.NamedValues
            Get NamedValueAdd NavigateData.NamedValues "OrderHeaOrderDateTimeMode" C_drEqual to NavigateData.NamedValues
        End
    End_Procedure
End_Object