Charlie: Yep, but thanks for the nudge.
Dave. 😄 Sent from my iPad > On Jan 9, 2015, at 4:09 PM, Charlie Noah <[email protected]> wrote: > > 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 <[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. > > -- > -- > 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.
