Date Format

  • Thread starter Thread starter ladybug via AccessMonster.com
  • Start date Start date
L

ladybug via AccessMonster.com

I have a table where the first field is a date range. This date range is a
text box. I am trying to combine two years of data. I understand of course
I cannot do a date range search since the format is not set to date. I have
added another column so that the year and month can be captured in a date
format.

Example:

DateRange YearMonth
01/01/06 - 01/07/06 06-Jan
01/08/06 - 01/14/06 06-Jan
01/07/07 - 01/13/07 07-Jan
01/14/07 - 01/20/07 07-Jan
02/04/07 - 02/10/07 07-Feb

How do I set the date format to accept the date format for YearMonth. In
Excel's formula bar it shows up as 01/01/06. In the Excel field it says 06-
Jan. When I load this data in Access it changes to 01/06/07. Can someone
help me figure out how I can do this or an easier way to do it?
 
Set the format of the text box to:

yy-mmm

IF the text box looks like "2006-Jan", go to Main meni TOOLS/OPTIONS/GENERAL
and uncheck the check box "Use four-digit year formatting" check boxes.

HTH
 
Back
Top