Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations dencom on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: frieb
  • Content: Threads
  • Order by date
  1. frieb

    Add 5 hours to a DateTIme field

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

    Converting DateTime to include Time

    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...
  3. frieb

    DATEDIFF in MInutes

    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...
  4. frieb

    Page Footer not printing on Page 1

    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?
  5. frieb

    Sorting on a TRIM field

    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!
  6. frieb

    Yesterday's Date to the Current Report RunDate

    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

Part and Inventory Search

Back
Top