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 TouchToneTommy 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: ocs
  • Order by date
  1. ocs

    Importing Date using Teradata Sql Assistant

    The date needs to be in the same format as the default format of the field in the table or you need to tell teradata what format the date is in. Help table dbcname.tblname should give you the format of the date field (for example yyyy-mm-dd). If you change the format of the date in the text file...
  2. ocs

    Changing parameter input from 05/10/2003 to 20030510

    Assuming {?datepar} is the parameter and the input date format is mm/dd/yyyy (ex: 12/31/2002), val(mid({?datepar},7,4)+left({?datepar},2) +mid({?datepar},4,2)) should fit the bill.
  3. ocs

    Cant open Crystal Rptt file from any location other than Crystal Rpt

    Sounds more like a Windows Association problem. Check out the (Windows Explorer/View/Options/File Types/...) association for '.rpt' files 'Crystal Report'. Go into Edit and check that the path is correct for CRW32.exe.

Part and Inventory Search

Back
Top