Format to use when inserting Date data type

[Catrina]

I am trying to insert user input into an Access database field that is a Date data type. The data is collected in a textbox. (Entered as 09182000). I need to convert this string for use in the date data type Access field. Any suggestions?

Catrina [sig][/sig]

 

[MichaelRed]

a) try using the format property of the text box to "suggest" a propper date format.

b) parse the entry to divide it into the "proper" pieces and generate a date formatted value from the results before placing the info into the data base.

("A)" is highly recommended! (it is a lot less work!!!!))
[sig]<p>MichaelRed<br><a href=mailto:mred@duvallgroup.com>mred@duvallgroup.com</a><br>There is never time to do it right but there is always time to do it over[/sig]