>>>I am dealing with a project in Visual Foxpro which is having a database of Historical data. I am facing with the problem of entering date that is before 100th century. AD. how do I solve this problem?
>>
>>Matt's reply is correct, VFP can handle dates in the range of 01/01/0100 through 12/31/9999 so you can't enter dates in the first century A.D., at least not as date fields. Do you really need full month-day-year information for historical dates that far back? In addition to Matt's suggestion, if all you need is the year, you might want to consider using a character or numeric field to store it.
>>
>>BTW, here's a GOTCHA I recently discovered when working with dates: it appears that the GOMONTH() function doesn't work on any dates prior to 01/01/1752. It returns the empty date when used with any earlier dates.
>>
>That's when the Western calendar system went from Julian to Gregorian, I believe. They'd need a different function for time prior to that...
Actually, it was the other way around..
Therefor Julian day 1 = 01/01/1752 which affects SYS(1) and SYS(11,)
Matt McDonnell
...building a better mousetrap with moldy cheese...