TO UNSUBSCRIBE: email "unsubscribe issforum" in the body of your message to
[EMAIL PROTECTED] Contact [EMAIL PROTECTED] for help with any problems!
----------------------------------------------------------------------------
Well, apparently if you do not use a 3rd party product (Crystal Reports) you
are stuck using the time that ISS determined everyone would be happy with
(GMT)????!!!!!
At any rate, for all of you that have access to Crystal Reports (8.0 or
newer is required) and want to see your Time Zone on reports, this is what I
have done to make it work. I am not a programmer, so this may or may not be
the "best way!"
*Make a backup copy of the report you want to change.
*Open the report in design view
*right click on the @EventDate field object
*Select Edit Field object and the Formula Editor will appear
*Delete the ISS Formula and add the following:
DateAdd ("h",x, {Events.EventDate})
the "x" is actually how many hours + or - your time zone is off of GMT. The
"h" indicates Hours. So for my time zone, my formula looked like this.
DateAdd ("h",-5, {Events.EventDate}
Save this formula and presto, My times appear in CST! Downside is Daylight
Savings time will require a change to my formula.
Also, the report I was working with was the canned "Event Name Report".
There are 2 time fields called @FromDate and @ToDate that show the start and
end dates and times included in the report. To change these, edit the
formula the same way.
@FromDate = DateAdd ("h",-5, Minimum({Events.EventDate}))
@ToDate = DateAdd ("h",-5, Minimum({Events.EventDate}))
Good Luck!
Jim
--Original Message-----
From: Weeks, John G. [mailto:[EMAIL PROTECTED]]
Sent: Friday, June 21, 2002 8:20 AM
To: Weeks, Jim
Subject: RE: GMT on reports (Real Secure Network Sensor V6.5 console)
Let me know if you find out how to...? Thanks
-----Original Message-----
From: Weeks, Jim [mailto:[EMAIL PROTECTED]]
Sent: Thursday, June 20, 2002 5:14 PM
To: '[EMAIL PROTECTED]'
Subject: GMT on reports (Real Secure Network Sensor V6.5 console)
TO UNSUBSCRIBE: email "unsubscribe issforum" in the body of your message to
[EMAIL PROTECTED] Contact [EMAIL PROTECTED] for help with any
problems!
----------------------------------------------------------------------------
Has anyone been able to get the "canned" reports to display specific time
zones? I understand how to change the selection criteria to "Local Time",
but I actually want local time to display on reports for management?
Any help is appreciated.
Thanks,
Jim
