how i can use the date field

R

reneabesmer

i have been working in an NGOs so i need how to used in Ms Access the Data
Field according 2 my Desires
when i design the table so i need a date Field one of them so when i select
the Date field so then i need 2 format them like Medium or Shortdate
but it don't work out for me because i need 2 write date in two different
types in the Ms Access Table , for example
1-jan-1980
3-jul-2055
1950
20-Apr-2005
1986
 
J

Jeff Boyce

The Date/Time data type field stores date AND time information.

How you display it (Medium, Short...) is controlled by the format. The
format doesn't change how it is stored.

If you are trying to control a date's appearance, do so in a form. Tables
store data, forms display it.
 

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

Top