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 Westi 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: *

  1. WiZoRioT

    Converting DateTimeValue with Milliseconds ??

    Just as an FYI I was able to use the following method as well datetimevalue(left({yourtable.yourfeild},19))
  2. WiZoRioT

    Converting DateTimeValue with Milliseconds ??

    OUTSTANDING! Worked like a charm.. my first thought was to trim off the millisecods as well but couldnt figure out the proper syntax to do so.. Thank you so much for your help. Regards, WiZoRioT.
  3. WiZoRioT

    Display data horizontal rather than vertical

    Under the selection expert you can select a format with multiple columns then adjust your layout in the corresponding tab. Or Create a crosstab then in the crosstab properties you can select horizontal. Regards, WiZoRioT
  4. WiZoRioT

    Converting DateTimeValue with Milliseconds ??

    Please Help, Im connecting to a SQL Server via ODBC. When I look at the Date Time Feild in the Database it is a Sting Value with the following format: 2004-06-08 17:09:47.202 I need to convert this into a DateTime Value.. When I try to apply the formula...
  5. WiZoRioT

    Average Formula

    Newbie to Crystal am I! My first attempt at a report in crystal is gather data for LastFullMonth filtering for Priority 1 Issues. I can gather the data via (ODBC) and present it nicely (even have a litle graph to show number of Incidents perday). I created a formula for Time To Resolution...

Part and Inventory Search

Back
Top