UflTimeZone

$ 199.00$ 1,999.00

UFLTimeZone for Crystal Reports provides Epoch date and time-zone-to-time-zone conversion functions to Crystal Reports, Crystal Enterprise and Business Objects users. Moreover, the UFL applies each time zone’s seasonal adjustment (e.g. Daylight Savings), should it be desired.

Clear

Description

UflTimeZone provides Epoch-date and timezone-to-timezone conversion functions to Crystal Reports, Crystal Enterprise and Business Objects users. Moreover, the UFL applies each time zone’s seasonal adjustment (e.g. Daylight Savings), should it be desired.

Moreover, UflTimeZone is fully compliant with the new, 2007 Daylight-Savings Time settings.

Feature Benefit
Converts between Epoch dates (#seconds since 1/1/1970 00:00:00 UTC) and Windows dates.1 Interface with Remedy data more easily: Join multiple tables or views without restrictions (requires the use of an ODBC that supports joins). Use any native or ODBC driver to connect to data.
Converts between timezones. Internationalize your report with little effort.
Adjusts for Daylight Savings. Save time and increase accuracy by eliminating complicated, error-prone logic from your Crystal Reports.
Architected as a static DLL. Work with Crystal Reports 5 or later, Seagate Info 5 or later or Crystal Enterprise 8 or later.

Downloads

Partial Client List

  • General Mills
  • Prudential
  • US Department of Energy
  • Verizon

Functions

EpochDateToGmt()

The “EpochDateToGMT” function converts an Epoch date (the number of elapsed seconds since 01/01/1970 00:00:00 AM at UTC) into a date/time string at Greenwich Mean Time. The format can be any date or date/time format used as configured in Microsoft Windows™ or Crystal Reports™.

EpochDateToLocalDate()

The “EpochDateToLocalDate” function converts an Epoch date (the number of elapsed seconds since 01/01/1970 00:00:00 AM at UTC) into a date/time string, in a specified time zone, applying seasonal adjustments (e.g. Daylight Savings) if desired.

ESPs_ARSToLocalDate()

The “ESPs_ARSToLocalDate” function converts an Epoch date (the number of elapsed seconds since 01/01/1970 00:00:00 AM at UTC) into a local date.

ESPs_ARSToLocalDateTime()

The “ESPs_ARSToLocalDate” function converts an Epoch date (the number of elapsed seconds since 01/01/1970 00:00:00 AM at UTC) into a local date/time.

ESPs_ARSToLocalTime()

The “ESPs_ARSToLocalTime” function converts an Epoch date (the number of elapsed seconds since 01/01/1970 00:00:00 AM at UTC) into a local time.

GmtToEpochDate()

The “GMTToEpochDate” function converts a date/time string, at UTC, into an Epoch date (the number of elapsed seconds since 01/01/1970 00:00:00 AM at UTC).

GmtToLocalDate()

The “GMTToLocalDate” function converts a date/time string at UTC into a date/time at a local Time Zone with seasonal adjustment if desired and applicable (e.g. Daylight Savings).

LocalDateToEpochDate()

The “LocalDateToEpochDate” function converts a date/time string, in a specified time zone, applying seasonal adjustments (e.g. Daylight Savings) if desired, into an Epoch date.

LocalDateToGmt()

The “LocalDateToGMT” function converts a date/time string at local time zone into a date/time string at UTC, taking in account seasonal adjustment if desired and applicable (e.g. Daylight Savings).

Revision History

1.2.9.0 (3/6/2007)

[+] Added support for dynamic Day-Light-Savings time changes, including the US 2007 DST changes.
[+] Added three new functions in the DLL: ESPs_ARSToLocalDate(), ESPs_ARSToLocalDateTime(), ESPs_ARSToLocalTime()–they have been added at the request of a client. They have the functionality of calling EpochToLocalDate(,””,true), but returning a Date, DateTime, and Time value, respectively.
[+] Added new sample files.
[+] Update the documentation.
[-] Removed the workstation/server restrictions of earlier versions. This was done to make it easier for customers to deploy the product. The licensing, however, has not changed.

1.2.5.0 (3/10/2004)

[+] Fixed calculation errors that occurred during daylight shifts.

1.2.2.0 (7/20/2003)

[+] Fixed an error when the TimeZone parameter’s value is set to “”. In this case, the UseSeasonalAdjustment parameter’s value will now be ignored, as documented.

1.2.1.0 (3/10/2003)

[+] Improper installation of workstation license on a server OS (or server license on a workstation OS) degrades gracefully.
[+] Fixed calculation errors that occurred during daylight shifts.

1.2.0.0 (8/12/2002)

[-] Dialog boxes in the 30-day-trial version were affecting Crystal Enterprise’s operations. As a result, all pop-up messages were removed.

Notes

  1. Epoch dates before 1/1/1970 00:00:00 UTC are not supported.

Additional information

License

workstation, server

Reviews

There are no reviews yet.

Be the first to review “UflTimeZone”

Your email address will not be published. Required fields are marked *