Have you issued a SET CENTURY ON in your application? I think that will allow you to enter 4 digits for a year.
Larry
>Hi
>
>I am having problems writing a report in foxfire. What happens is that when I put in a date of 01/01/00 for instance it assumes it is 01/01/1900 (I guess) . Unfortunately foxfire does not let me enter a 4 digit date only two. I can get around this by removing the ctod() function in the SQL statement and replacing it with the {} date brackets. This however is not very end user friendly, does anyone know if there is an update to foxfire 3 for foxpro 2.6a that gets around this or is there a user friendly way to do this.
>
>Thanks
>
>Nick Steele
Larry Huisingh
Lockheed Martin Information Technology
Richland WA USA