date format

M

mhmaid

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.
 
A

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.
 
Top