Crystal Reports for Eclipse Designer Guide

Date

The CDate and DateValue functions are equivalent to Date.
Description
Returns a Date value.
Overloads
  • Date (number)
  • Date (string)
  • Date (dateTime)
  • Date (YYYY, MM, DD)
  • Arguments
  • number is a value representing the number of days starting from December 30, 1899. It can be positive or negative, and is truncated if fractional.
  • string is a text string representing a date, example: "September 20, 1999".
  • dateTime is a DateTime value.
  • YYYY is a whole number representing a year; MM is a whole number representing a month; DD is a whole number representing a day of the month.
  • Returns
    A Date value.
    Action
  • Date (number) returns a Date value given a number of days starting from December 30, 1899.
  • Date (string) returns a Date value given a string that represents a date from January 1, 100 through December 31, 9999.
  • Date (dateTime) returns the date portion of a given DateTime value.
  • Date (YYYY, MM, DD) returns a Date value given numeric arguments of the year, month, and day.
  • Examples
    Date ("Dec 31, 1999")
    Returns the Date value for Dec. 31, 1999.
    Date (50)
    Returns the Date value for February 18, 1900.
    Date (#Oct. 20, 1999 12:02pm#)
    Returns the Date value for October 20, 1999.
    Date (1930, 7, 30)
    Returns the Date value for July 30, 1930.
    Comments
    You can use the IsDate function to check if a String argument can be converted to a Date before doing the actual conversion. That way, if the conversion cannot be done, you can handle the situation appropriately.



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