date format

  • Thread starter Thread starter Guest
  • Start date Start date
G

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Stumped By Dates 4
Date formats 1
Forcing a date entry format of dd/mm/yyyy 1
date calculations - please help 2
Date problem 5
WHats wrong with this query? 4
Format Current Date 3
Mail Merge Date Format 9

Back
Top