Date Fields In Access

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

 

[Rick B]

It is possible. Use the "DATEPART" or the FORMAT feature.

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

= Format([SomeDateFieldName],"DD")

 

[John Vinson]

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.

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]