 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Modules / DAO / VBA / May 2007Date Format
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  SignatureSteve S -------------------------------- "Veni, Vidi, Velcro" (I came; I saw; I stuck around.) > 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 [quoted text clipped - 15 lines] > 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? |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.