>i made the insert like "INSERT INTO tablename values(alltrim(thisform.text1.value))"
>text1 is the input box for the date
You made some mistakes here.
1. If the field is Date type and the textbox is also a date ALLTRIM() will fail. It accepts ONLY strings.
2. If the field is Date type but TextBox is char this INSERT will fail because Date VFP soes not make inplicit convertion between string and Date. use CTOD() as Hilmar suggested.
3. If the field is char but TextBox is Date type INSERT also will fail (see #2) use DTOC().
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.