you are right Dan . I discovered the cut-off year after I sent mail. Thanks for reply. I have modified my input screens to accommodate 4 digit year if I need to over-ride the default. we have a lot of members whose b-day are before 1930.
Dave Sent from my iPad > On Jan 9, 2015, at 3:03 PM, Daniel Klein <[email protected]> wrote: > > 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. -- -- 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.
