@td gives /OV

[Robert Repko]

Ken,

Your suggestion of using 'mesgbox "PFCMARK='" & getenv("PFCMARK") & "'"' showed me the problem.  Although I have PFCMARK set in profile as 25 in filePro config file it was set to 15.  I never would have thought to check there, thank you.

-----Original Message-----
From: Kenneth Brody [mailto:kenbrody at spamcop.net] 
Sent: Thursday, April 13, 2017 5:56 PM
To: Robert Repko; Filepro-list at lists.celestial.com
Subject: Re: @td gives /OV

On 4/13/2017 2:35 PM, Robert Repko via Filepro-list wrote:
> Ken,
>
> PFCMARK=25
> Thanks for the suggestion of using @t4, I didn't think of that.  I tried @t4 and that works.  I just don't understand why @td gives an error.

If PFCMARK is set to 25, then filePro's 2-digit-year dates can work up to 31-Dec-2024.  I don't know why @TD is returning an overflow.  You could verify the value with

     mesgbox "PFCMARK='" & getenv("PFCMARK") & "'"

Perhaps something/someone has changed the setting?

Regardless, by using 4-digit-year date fields, you eliminate this as an issue.


>
> -----Original Message-----
> From: Kenneth Brody [mailto:kenbrody at spamcop.net]
> Sent: Thursday, April 13, 2017 2:27 PM
> To: Robert Repko <rtr at rsquared.com>; Filepro-list at lists.celestial.com
> Subject: Re: @td gives /OV
>
> On 4/13/2017 12:06 PM, Robert Repko via Filepro-list wrote:
>> Running filePro 5.7.00.04R4 on SCO Unix 5.0.7 In a processing table I 
>> assign a numeric value to a variable based on the month of a date 
>> (@td).  I'm getting /OV in that variable When debugging a processing 
>> table I get /OV when I press 'f' for field and enter @td.
> [...]
>
> What is PFCMARK set to?
>
> Alternatively, use @T4 for the 4-digit-year version.

--
Kenneth Brody