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 Wanet Telecoms Ltd 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: Papagovas
  • Content: Threads
  • Order by date
  1. Papagovas

    Expression evaluation error

    Hi I'm using PCC V10 I have this query that works fine, until I Query for dates greater or equal to a certain date,which I get an Expression evaluation error. I also get the same Error when checking for values is not null. SELECT Process_LOG.Process, Process_LOG.OE, IF(shp.Shiped is...
  2. Papagovas

    Conveting a char to date

    Hi I'm using pcc v10 I have a column Char that has this data like this 'Y/N _ SHIP (20YY/MM/DD) 20__/__/__', (default) or Y/N y SHIP (20YY/MM/DD) 2019/01/17' . I'm pulling just the date using the if function. If(Substring(shp.Shiped, 29, 10) = '20__/__/__', NULL, Substring(shp.Shiped...

Part and Inventory Search

Back
Top