How do I display Month/Year only?

  • Thread starter Thread starter Spectrex
  • Start date Start date
S

Spectrex

Guest
I am modifying a current report that lists calibrated instruments and thier calibration due date. Right now, I enter the date that the item was cal'd (dd/mmm/yy), and Access adds the interval from the "interval" field (180 days or 365 days) and displays the Due Date as dd/mmm/yy. Since the calibrations are good until the end of the month after that interval, I need to be able to display only the month/year in the "Due Date" field. Does anyone know a simple way to do this? Thanks in advance.:D
 
ON the text box for the Next Calibration date, format it using mmm-yy that should return just the month and year - thus Mar 04
 
Thanks!

I appreciate your help! I wasn't aware that you could enter the format that way. I thought you were limited to the listed options. Thanks again! :D
 
Spectrex said:
Access adds the interval from the "interval" field (180 days or 365 days

Are you adding these in days? Wouldn't adding in 6 months and one year intervals be safer?
 

Users who are viewing this thread

Back
Top Bottom