Ahhh foxpro has a mind of it's own!<BR><BR>let me link you to an article I wrote many moons ago, it will help you understand dates a little better.<BR><BR>http://www.readthe****ingmanual.co.uk/articles/article_15.asp<BR><BR>now you can update the current entries with something like<BR><BR>update <table> set <field> = NULL Where <field> = #12/30/1899#<BR><BR>I'd make a backup of the table and check the syntax before trying this
[http://www.readthe****ingmanual.co.uk/articles/article_15.asp]<BR>Love that site!!! LOL You made my day.<BR><BR><BR>Thanks for the quick reply...<BR>This is not my database/application. I am purely displaying live data on my clients site. Dont want to go messing with that accounting system.<BR>Any new records inserted into the database from the application will have Null value's.<BR>Your solution would work but temporarily.<BR>Need to work around this issue.