DateTime Formula

[cathey04]

We are use HP Service Desk, release 4.5, running on Oracle 9 / HPUX. I found out last week that the database datetime fields when added after the views are generated, the data stored in the database is stored as GMT and will not show times according to the timezones or daylight savings (these are not in the views). In order to resolve this according to HP is to regenerate the views and assign the timezone MST). We would like to avoid this right now because we are 24 x 7, and I would like to know if there is some kind of formula I could use that would subtract 7 hours from the date/time stamp. Thanks

 

[synapsevampire]

Try a Crystal formula of:

dateadd("h",-7,{table.datetimefield})

If speed is an issue, use a SQL Expression in Crystal to do this so it's process on the server, the syntax is similar.

Also, pelase remember to post your software version...

-k

 

[cathey04]

This worked as a formula and it was slow as you suggested. I do not know how to write a SQL Expression. Here are the software versions

HP Service Desk, Service Pack 4.5
Oracle 9 (HPUX OS)
Crystal Reports 10

Thanks so much.