User Profile

Collapse

Profile Sidebar

Collapse
harrywhelks
harrywhelks
Last Activity: Aug 12 '10, 11:18 AM
Joined: Jun 17 '10
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • harrywhelks
    replied to Crystal Reports Date/Time Issue
    in SQL Server
    Update on previous post

    Hi,

    As an update to the last post, here is how it is done.
    No need for user friendly columns although these can be very useful for displaying on the report itself.

    You bring in the column from the database (fopen DateTime) and you create a parameter of type Date called DatePicker. Then you click on the filter shaped icon to open the Select Expert and add the below line...
    See more | Go to post

      Leave a comment:

    • harrywhelks
      replied to Crystal Reports Date/Time Issue
      in SQL Server
      Returning user friendly date formats from SQL Server

      I agree. The date calendar prompt thinggummyjig is a damned nuisance. And the convert function supplied by a previous post puts the date in mm/dd/yyyy which is US not UK version.
      select convert(varchar , getdate(),101)
      06/17/2010

      I'm sure there is another format code to get it in the UK version but personally I normally select the date in my stored procedure...
      See more | Go to post

        Leave a comment:

      No activity results to display
      Show More
      Working...