Razzak, Thank you very much for solving my date issue. I'll have to be more careful. Thanks again, Angelo ________________________________ From: rbase-l@googlegroups.com <rbase-l@googlegroups.com> on behalf of A. Razzak Memon <raz...@rbase.com> Sent: Thursday, May 4, 2017 12:03:08 PM To: rbase-l@googlegroups.com Subject: Re: [RBASE-L] - Date Issues
Angelo, That is the result of your DATE SEQUENCE settings to MMDDYYYY. Change the DATE settings as follows: SET DATE FORMAT MM/DD/YYYY SET DATE SEQUENCE MMDDYY That should take care of it. Very Best R:egards, Razzak At 02:52 PM 5/4/2017, angelocappe...@msn.com wrote: >I have a problem with my date fields. For years I have processed >selected records controlled by a starting and ending variable in >selecting records by date or date range. All of a sudden I get the >message #2059 No Records Found. > >When testing I use a browse command to find my problem and get the >same results. If I compare using the formats MMDDYY or MM/DD/YY no >records are found but if I use the format MMDDYYYY or MM/DD/YYYY I >get the correct data. > >I am running version 9.5 My config settings are Date Format is >MM/DD/YY, Date Sequence is MMDDYYYY, Century threshold year is >30, and my default century is 19. > >I would appreciate any suggestions to what happened and how do I fix it. -- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to rbase-l+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout. -- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to rbase-l+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.