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