Skip navigation
Currently Being Moderated

Converting report dates between UTC and Local Time in Crystal 10 or earlier

VERSION 3  Click to view document history
Created on: Nov 12, 2008 4:39 PM by CCrossfield - Last Modified:  Jul 14, 2010 5:48 AM by KarenPeacock

How do I convert date time fields between UTC and Local Time in Crystal?


There is a  free component you can download from the website below.  The installer is for Crystal 9 so instead copy

the .dll file manually to \windows\system32 and restarted Crystal.


You can then see the new functions under the Additional Functions item in the Function Tree, in the module named Win32. I used the one below and it seems to have done the trick:


UtcToDateTime (Adjusts a DateTime value in UTC to local time.)


Crystal 10 or earlier.  This does not work on 2008 servers or any 64bit machines.  You could instead write your own conversion formula


For Crystal 11 please see the following article:

Comments (0)
LANDESK Community powered by Jive SBS®  |  Legal Notices  |  Privacy Policy  |  Icon 

TweeterOn Twitter  |  Icon FacebookOn Facebook © 2007 LANDESK Software