Skip to content

DateToString - cDRReportHelper

Methods

Method Type

Function

Return Type

String

Arguments

Argument Description
dIn Date value to be formatted as string.

Description

This function can be used to format a Date variable as a string in a YYYY-MM-DD 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 sOrderHeaOrderDate

        WebGet psValue of oOrderHeaOrderDate to sOrderHeaOrderDate
        If (Not (IsNullDateTime (sOrderHeaOrderDate))) Begin
            Get DateToString of oReportHelper sOrderHeaOrderDate to sOrderHeaOrderDate
            Get NamedValueAdd NavigateData.NamedValues "OrderHeaOrderDate" sOrderHeaOrderDate to NavigateData.NamedValues
            Get NamedValueAdd NavigateData.NamedValues "OrderHeaOrderDateMode" C_drEqual to NavigateData.NamedValues
        End
    End_Procedure
End_Object