Date Fields In Access

  • Thread starter Thread starter news.microsoft.com
  • Start date Start date
N

news.microsoft.com

Hi again group

I need to extract the day and month from a date field and place these values
into 2 seperate fields ([day] and [month]). Is this possible in access ??

Thanks in anticipation.
 
It is possible. Use the "DATEPART" or the FORMAT feature.

For example, in an unbound text field, you could put...

= Format([SomeDateFieldName],"DD")
 
Hi again group

I need to extract the day and month from a date field and place these values
into 2 seperate fields ([day] and [month]). Is this possible in access ??

Thanks in anticipation.
Click to expand...

These fields should NOT be stored in your table of course, they're
redundant.

What you can do on a Form is create two textboxes bound to the date
field. Be sure to set their Locked property to True, Tab Stop to No,
Enabled to No so users can't edit them; set the Format property of one
of them to

"d"

and the other to

"mmmm"

to show 26 and April respectively.

John W. Vinson[MVP]
 
Back
Top