Autofill one field based on value in another

[Zburnsie]

What I am needing and not sure how to accomplish is the records that have a
date entered in this format (mm/dd/yy) I want to convert that date to mmm-yy
for use in pivot tables by month instead of individual dates - so what I was
thinking of doing was taking and autofilling another field from the date
field in that format - Is this the best way? if so, then what would the code
be? If not what would you suggest.

Thanks

 

[Jerry Whittle]

Adding a field derived from another is almost always a bad idea.

Also if your "date" field is a date/time data type, the Pivot Table wizard
will present you with the option to group by month, week, day, year, quarter,
etc.

 

[Zburnsie]

Ok I understand - now to figure out my Pivot table then - Thanks so much!