That doesn't make sense. The default 'pivot' year is '30' such that two
digit dates are converted as follows:
00-29 2000->2029
30-99 1930->1999
For example, running this code...
internaldate = ICONV('1-1-43','D') ;* simulate the input of a date with a
2-digit year
CRT OCONV(internaldate,'DY')
returns '1943' (not '2043').
The jBASE environment variable 'JBASE_PIVOT_YEAR' (only valid on jBASE 5)
can be used to change this behavior. For example:
set JBASE_PIVOT_YEAR=50
Running that same code now returns '2043'.
Dan
On Fri, Jan 9, 2015 at 12:06 PM, David Grenfell <[email protected]>
wrote:
> Happy New Year:
>
> question regarding input of dates
>
> Has any-one developed an algorithm to automatically insert the proper
> century into a field other than have a 4 digit entry for the year.
>
> My data all looked perfect on the screen and I never thought much about it
> until I tried to do a sort on the birth dates of the members in my data
> base.
>
> I found that birthdays for old folks (me included) has the year as 2043
> instead of 1943. I can’t think of any way to fix this other than to expand
> my birthday field to include a 4 digit input for year and then change each
> member individually, but if there is a simpler solution, I’m all ears.
>
> Dave
>
>
> --
> --
> IMPORTANT: T24/Globus posts are no longer accepted on this forum.
>
> To post, send email to [email protected]
> To unsubscribe, send email to [email protected]
> For more options, visit this group at
> http://groups.google.com/group/jBASE?hl=en
>
> ---
> You received this message because you are subscribed to the Google Groups
> "jBASE" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to [email protected].
> For more options, visit https://groups.google.com/d/optout.
>
--
--
IMPORTANT: T24/Globus posts are no longer accepted on this forum.
To post, send email to [email protected]
To unsubscribe, send email to [email protected]
For more options, visit this group at http://groups.google.com/group/jBASE?hl=en
---
You received this message because you are subscribed to the Google Groups
"jBASE" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/d/optout.
