Date Format, please help!!

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

This may be a very simple question but i am not an experienced access user.

I have a date field in the format - 'dd/mm/yyyy' I am trying to get get
access to recognise the date in just months and years and forget about days.
I have used the syntax 'Right' and have extracted the month and year but
access does not then recognise the fact that it's a date.
I have also changed the format to 'mmm yyyy' (the format i want it in) but
it still takes the day in to concideration in a table.

How can i get access to only look at the month and year?
 
You can't. You can change it to a text field and store those values. You
can make it into two separate fields and store those values. Or you can do
exactly what you are doing - store a real date and only DISPLAY the month
and year. Access stores date as a number that represents the number of days
since a set point in time. It will always store an exact date.
 
Back
Top