Selasa, 29 Januari 2013

[MS_AccessPros] Formatting a new date field

 

I have a table where the date that a club was chartered is stored in
a field called "DateChartered" by some stroke of genius!

I am preparing a list for this year that will record that on the
"CharteredDate" day and month but this calendar year in date format,
because we will sort on that field. A separate field will record that
the date is the anniversary.

From a field that shows 27/3/1927 how do I get a field that shows 27/3/3013?

Many thanks,

Robin Chapple

__._,_.___
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (1)
Recent Activity:
.

__,_._,___

Tidak ada komentar:

Posting Komentar