Crystal Reports for Eclipse Designer Guide

ShiftDateTime (inputDateTime, inputTimeZone, newTimeZone)

Description
ShiftDateTime shifts a DateTime value from one time zone to another time zone.
Arguments
  • inputDateTime—a DateTime value to be shifted.
  • inputTimeZone—a "TimeZoneString" representing the time zone of the inputDateTime.
  • newTimeZone—a "TimeZoneString" representing the time zone to which the inputDateTime is shifted
  • Returns
    A DateTime value.
    Action
    ShiftDateTime shifts a DateTime value from one time zone to another time zone.
    Example
    ShiftDateTime (DateTime (2000, 1, 1, 12, 0, 0), "EST,300,EDT", "PST,480,PDT")
    Returns 1/1/2000 9:00:00AM
    In this example, noon Eastern Daylight Time is shifted to 9 am Pacific Daylight Time.
    Comments
    Time zones are represented by TimeZoneString, which is a string that follows these formats:
  • "std,offset,dst,[offset];start[/time],end[/time]"
    Example: "PST,480,PDT,-60;4.1.0/02:00,10.1.0/02:00"
  • "std,offset,dst,[offset]" (if the time zone follows the US Daylight Saving Time (DST) rules)
    Example "PST,480,PDT,-60"
  • "std,offset" (if there is no DST)
    Example "South Africa,-120"
  • "" (an empty string indicates the local time zone from the OS settings)
    Syntax
    Description
    std
    String name of the standard time zone.
    offset
    Offset, in minutes, of the standard time zone (west is positive).
    dst
    String name of the DST time zone.
    offset
    Optional DST offset from standard (defaults to one hour ahead of standard offset).
    start
    Date when DST goes into effect. The format is m.w.d—representing the month, week, and day number of the date. w=1 is the first week of the month, and w=5 is the last week of the month.
    time
    Optional time that DST goes into effect (24-hour clock). The default is 02:00 (local to the given time zone).
    end
    Date when time zone changed back to standard.



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