date format

[Guest]

i have one field "TransactionDate" and in my table i have set its default
value to "=date()".so and date format to dd/mm/yyyy . Now if i add a record ,
it will assign todays date to this field. but unfortunatley, it is storing
also the time .

i want it to store only the date .
what should i do.

 

[Arvin Meyer [MVP]]

Access always store the time, but it stores 0 (midnight), if the time isn't
supplied. If you are displaying the time, somewhere it is being formatted to
display.

 

[Damon Heron]

Format table field to Short Date not General Date.

Damon