Search results for query: *

THANKS SO MUCH! That worked!

Version 11.5........ Sorry, I need to subtract 5 hours (not add)

I need to add 5 hours to a DATETIME field due to Greenwich Time. I need to know what the formula would be.

Crystal 11.5

WIthin Crystal I have a datetime field (date) that only displays the date and in the database it does display the date and time. What do I need to do to convert this field to display both the date and time on the report? From here, I will need to use the DateDiff (s) functionality to get the...

It looks as though it is only reading the date stamp and not the time stamp. Do I need to declare any variable or set any report options differently?

datediff("n",currentdatetime,currdatetime-1) What does it return? 1440

oops. Formula returned 1400 in minutes and 86400 in seconds

Trying to calculate the number of minutes between two datetime stamps. Here is what I have - using Crystal 11.5: datediff("n",{text_document.EndDictTime},({text_document.CreateTime})) EndDictTime for this record = 7-21-2006 11:13:00 CreateTime for this reocrd = 7-22-2006 20:00:00 Above...

Thanks Bob, moving the cross tab report to the report footer worked. Thanks Again!

My Page Footer information is not printing on any page except for the last page of the report. I need the page footer to print on every page. Are there some settings I should verify to make sure I don't have something on/off that shouldn't be?

I'm trying to sort a TRIM (field) in Ascending order (which is also a group). Here is the order I want it to sort in: 2 4 7 9 12 22 This field is currently sorting as: 12 2 22 4 7 9 Thanks!

Need help with Date Forumula: Need Yesterday's data up to the time the report is run the next day. For example: Report is Run Today (8/8/05) @ 7:00 AM. The report needs to return records for 8/7 (24 hours) and 8/8 (7 hours.) Crystal 10, SQL Database