I can't find a date :)

[BFP]

OK, I know people out there are doing this: I have a date field in my table and I want my form to either display the current date if I start a new record, or show the date listed in the table. I want the format to be:<br>MMM DD, YY.<br><br>As simple as this sounds, I am having problems.<br><br>Regards,<br><br>--Dan

 

[JimHorton]

have you tried...<br>format(date(),&quot;MMM DD,YY&quot<br><br>

 

[Guest_imported]

Yes, but this shows the current date and not the date originally entered in the table.&nbsp;&nbsp;Also, I want to be able to enter a date.

 

[gol4]

My guess is you do not have the date field bound to the table<br>make sure the control source is set for you date field then under default value place date() then format uner format