Re: [RBASE-L] - Date Issues

2017-05-04 Thread A. Razzak Memon

Angelo,

That is the result of your DATE SEQUENCE settings to MMDD.

Change the DATE settings as follows:

SET DATE FORMAT MM/DD/
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 MMDD or MM/DD/ I 
get the correct data.


I am running version 9.5   My config settings are Date Format is 
MM/DD/YY,Date Sequence is MMDD,  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.


[RBASE-L] - Date Issues

2017-05-04 Thread angelocappe...@msn.com
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 MMDD or MM/DD/ I get the correct data.

I am running version 9.5   My config settings are Date Format is MM/DD/YY,
Date Sequence is MMDD,  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.


Thanks

Angelo Cappetta

-- 
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.