Chris Edwards

I had a heck of a time finding out how to convert a UNIX time stamp in Crystal Reports.  My company has a ecommerce package that stores all sales date in a UNIX time stamp format.  Which means it stores the time and date by storing the number of seconds since 1/1/1970.   So here is the formula I came up with…

dateadd (“s”,{order.date}-18000, #1/1/1970#)

dateadd function does the trick,  the “s” is for seconds, order.date is the table that contains the unix time stamp, -18000 is -5 hours from UTC in seconds because im in the Eastern Time Zone and 1/1/1970 is the base date for dateadd to add the other argument to.

Hope This Helps!

Chris Edwards

If you want to copy Putty configuration from a Windows computer to another same version Windows computer, here is what to do:

1. On a model computer, configure Putty to your desire, save and test it to make sure it works the way you want it to.
2. Start/Run/regedit to run regedit tool
3. Browse to HKEY_CURRENT_USER\Software\SimonTatham\PuTTY\SshHostKeys
4. Delete all values under this key EXCEPT the (Default) value
5. Right click on HKEY_CURRENT_USER\Software\SimonTatham and select Export, then save it as “setup-putty.reg” to a location that you want
6. Copy setup-putty.reg and the Putty.exe files to a machine that you want to copy Putty configuration to
7. On this new computer, double click on setup-putty.reg to import Putty configuration
8. Upon successful configuration import, run Putty.exe. You should see all Putty configuration there. You can safely delete setup-putty.reg since you only need to run it ONCE on each new computer that you want to use Putty with tthe same configuration.