Thanks, Danny. This "little info" was all I needed. It works perfectly now.
Have a Happy New Year! --Marc On Fri, 2005-12-30 at 10:28 +0100, Danny Stolle wrote: > Marc, > > In MySql (I am using 4.1.9 and 4.1.15; so i am not sure about 5) it is > not possible to use functions as default values; you could create: > create table tester (f_date date default curdate()); But this doesn;t > work. You have to struggle through your knoda how to present the current > date. Be sure you have your field datatype set to DATE. > Create your form and set the datasource to the table having the > date-field. Create your textbox and assign the field to it. > Put the %NOWDATE% in the 'default value' field of your textbox. The > currentdate will be shown after you run the form. > > Hope this little info helps you :-) > > Danny > -- Marc <[EMAIL PROTECTED]> -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]