formatting date and numeric fields

Originally posted by : Nic (annihilus@terra.es)Hi,I am very new to ASP and SQL and have a major trouble: using MS Access 2000 I have different fields with numeric and date values. Actually I have converted all these fields to text becouse I wasn't able to pass the data from an ASP page in other formats than text. Could anyone help me ? Tx in advance.

Originally posted by : Hi!!well still you can convert back to their original form which you have changed to text using CStr for textCDate for dateCInt for integer e.g CInt(myVar) where myVar was stored as string before..hope it works!cheers!!!rocky

Originally posted by : Paul (willmanp@akrr.com)hmmmm, I must be doing something wrong, because everytime I try using CDate, CInt or any of the other string data conversion functions, I always get a data type mismatch error.any idea why this might be happening to me? I mean, other than that these sorts of things always seem to happen to me.....thanks in advancepaul------------ at 8/26/2001 10:22:55 AMHi!!well still you can convert back to their original form which you have changed to text using CStr for textCDate for dateCInt for integer e.g CInt(myVar) where myVar was stored as string before..hope it works!cheers!!!rocky