Crystal Reports for Eclipse Designer Guide

IsDateTime

Description
IsDateTime returns True if the given String or Number value can be converted to a valid DateTime and returns False otherwise.
Overloads
  • IsDateTime (string)
  • IsDateTime (number)
  • Arguments
  • string is a String value or expression to be tested for being convertible to a DateTime value. Many forms are accepted.
  • number is a Number value or expression to be tested for being convertible to a DateTime value. It can be positive, negative or fractional. It is interpreted as a number of days since December 30, 1899.
  • Returns
    Boolean value (True or False).
    Action
    IsDateTime returns True if the given String or Number value can be converted to a valid DateTime and returns False otherwise. A valid DateTime is any date-time between January 1, 100 through December 31, 9999.
    Examples
    IsDateTime ("September 30, 1999")
    Returns True since the given string "September 30, 1999 is interpreted as the DateTime value September 30, 1999, 12:00:00am.
    IsDateTime (-100.2)
    Returns True since the given number argument is interpreted as the DateTime value September 20, 1899, 7:12:00 pm.



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