Ok I know I have been away from foxpro for awhile now and we still have a few fox tables around we use. I need to add a row to a fox table that contains a date. I am using a simple Insert command. Problem is the dot net DateTime structure is so different. Is there a way to change the format of get a format in C# Dot net that allows me to insert or update a fox table?
DateTime myDate = DateTime.Now;
Looks like 2/12/2008 11:35:44AM
fox expects a date to look like this {^yyyy-mm-dd, hh:mm:ssa}
I could parse this all out with a bunch of conversions but what a pain
string foxDate = "{"
foxDate += myDate.Year.ToString();
foxDate += myDate.Month.ToString();
etc. but this also would not quite conform since the month is 2 and would convert to "2" and not "02"
Ideas welcome.
Thanks
Tim
Timothy Bryan