Date Display.

Information Technology Department hbmsit@mb.sympatico.ca
Thu, 06 Aug 1998 12:01:07 -0700


Rod Hulme wrote:
> 
> Recently we have modified date item data in an Image database to include the century.
> 
> This data is accessed from COBOL programs as well as Powerhouse.
> 
> Before we changed the data, Powerhouse screens (QUICK729C) displayed date fields that had not had a value assigned to them as :       "  /  /  ".
> 
> After the data change these items are displayed as:  "   /  /1900" . I gather the default century is now being used for display.
> 
> In both cases if the field in the database has a value of 0 this does not happen.
> 
> Can anyone explain why this is so?  We have a proposed workaround but would like to understand why Powerhouse is treating the "null" value and the "0" value differently.
> 
> Cheers,
> Rod.
> 
> Rod Hulme
> RMIT University Melbourne

When you modified your data.  Did you blindly add "19" to all your
dates.  If you had a date with no date, then  what you're seeing is what
would happen.

Sam Perri
= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
Subscribe: "subscribe powerh-l" in message body to majordomo@lists.swau.edu
Unsubscribe: "unsubscribe powerh-l" in message to majordomo@lists.swau.edu
powerh-l@lists.swau.edu is gatewayed one-way to bit.listserv.powerh-l
This list is closed, thus to post to the list, you must be a subscriber.