Crystal Reports for Eclipse Designer Guide

DateTimeToSeconds (dateTime)

Description
Evaluates the DateTime value and returns the number of seconds that have passed between 00:00:00 (12:00 midnight) and the specified time.
Arguments
  • dateTime is a DateTime value.
  • Returns
    Time value (in seconds)
    Action
    Evaluates the DateTime value and returns the number of seconds that have passed between 00:00:00 (12:00 midnight) and the specified time.
    Examples
    DateTimeToSeconds(#11/01/1998 11:30:15 AM#)
    Returns 41415.
    Comments
    Instead of using DateTimeToSeconds (dt), you can use:
    DateDiff ("s", #12:00 am#, CDateTime (CDate(0,0,0), CTime (dt)))
    The above expression does not use UFLs and can be more efficient.



    SAP BusinessObjects
    http://www.sap.com/sapbusinessobjects/
    Support services
    http://service.sap.com/bosap-support/
    Product Documentation on the Web
    http://help.sap.com/