[Search for users] [Overall Top Noters] [List of all Conferences] [Download this site]

Conference ilbbak::ibi_focus

Title:	FOCUS, from INFORMATION BUILDERS

Moderator:	ZAYIUS::BROUILLETTE

Created:	Thu Feb 19 1987
Last Modified:	Mon May 05 1997
Last Successful Update:	Fri Jun 06 1997
Number of topics:	615
Total number of notes:	1779

233.0. "RDB/VMS date and FOCUS problem" by BTOVT::STODDARD_N () Wed Jul 05 1989 13:39

    We are currently testing FOCUS against an RDB database where we have
    all of our dates stored as VMS dates.  When FOCUS reads a date that
    has no date loaded into it, it displays Nov. 17, 1958.  We need to be
    able to check for date "eq ' '".  This does not work for us, because
    it considers the Nov. date to have a value.  The FOCUS masters have
    Usage=YMD and Actual=Date.  Does anyone else have this as a problem?
    
    Nancy

T.R Title User Personal
Name Date Lines

233.1 don't blame FOCUS FERNEY::OTT Wed Jul 05 1989 14:07 15

T.R	Title	User	Personal Name	Date	Lines
233.1	don't blame FOCUS	FERNEY::OTT		`Wed Jul 05 1989 14:07`	15
	Hello Nancy. > When FOCUS reads a date that > has no date loaded into it, it displays Nov. 17, 1958. If you put nothing in an RDB date field, RDB itself will consider the date as being Nov. 17, 1958. That's the zero-date for RDB/VMS. It's not a FOCUS problem. I guess you'll have to check in FOCUS if the date has precisely this value, instead of checking for blank. JD.

Hello Nancy.

>    When FOCUS reads a date that
>    has no date loaded into it, it displays Nov. 17, 1958.

  If you put nothing in an RDB date field, RDB itself will consider
the date as being Nov. 17, 1958. That's the zero-date for RDB/VMS.
It's not a FOCUS problem.

  I guess you'll have to check in FOCUS if the date has precisely
this value, instead of checking for blank.

  JD.