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 gkittelson 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. morristraveller

    AS400 null date value interpretation CR 10

    Thanks Ibass, but your suggestions won't work either as Crystal is receiving or reading the null date of 0001-01-01 as 2001-01-01 and so there is no null value to process. and if I change 2001-01-01 to a null with code I will be eliminating any valid 2001-01-01 date and I have no way to...
  2. morristraveller

    AS400 null date value interpretation CR 10

    Thanks Gary. I tried those and I still have 2001 in my null date field. Any other ideas?
  3. morristraveller

    AS400 null date value interpretation CR 10

    My IBM ISO dates storred on an AS400 (ISo date Format yyyy-mm-dd)are being interpreted correctly by CR 10 until a null date value is encountered the format for an AS400 ISO null date value is 0001-01-01. The date is being transformed into 2001-01-01 on my reports. I've reviewed the regional...

Part and Inventory Search

Back
Top