Crystal Reports for Eclipse Designer Guide

DTSToSeconds (DateTimeString)

Description
Evaluates the string specified and converts the Time value to the number of seconds from 00:00:00 (12:00 midnight) to the specified time.
Arguments
  • DateTimeString is a string including a Date and a Time value.
  • Returns
    Whole Number
    Action
    Evaluates the string specified and converts the Time value to the number of seconds from 00:00:00 (12:00 midnight) to the specified time.
    Examples
    DTSToSeconds("2000/01/13 11:30:15")
    Returns 41415.
    Comments
    Instead of using the DTSToSeconds function, you can use:
    DateDiff ("s", #12:00 am#, CDateTime (CDate(0,0,0), CTime (DateTimeString)))
    The above expression is able to convert more types of strings.



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