Autofill one field based on value in another

  • Thread starter Thread starter Zburnsie
  • Start date Start date
Z

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