Re: JBASE 3.X ON WIN 7

[Charlie Noah]

You are storing your dates ICONVed, aren't you? On 01-09-2015 2:15 PM, David Grenfell wrote: 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 <danielklei...@gmail.com> 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 <d.grenf...@hotmail.com> 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 jBASE@googlegroups.com To unsubscribe, send email to jbase-unsubscr...@googlegroups.com 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 jbase+unsubscr...@googlegroups.com. 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 jBASE@googlegroups.com To unsubscribe, send email to jbase-unsubscr...@googlegroups.com 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 jbase+unsubscr...@googlegroups.com. 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 jBASE@googlegroups.com To unsubscribe, send email to jbase-unsubscr...@googlegroups.com 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 jbase+unsubscr...@googlegroups.com. 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 jBASE@googlegroups.com To unsubscribe, send email to jbase-unsubscr...@googlegroups.com 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 jbase+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.