If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Need Date Field to just should MM YY
Hi All,
I need a date field to just show the Month and Year. I'm not precious about the exact format but the problem is that I have entered information into a text field as just (for example) June 2009, but I now need to do comparisons based on that field which I had not foreseen at the outset. Is there anyway to display a date as I need please. Ta. Bill. |
#2
|
|||
|
|||
Need Date Field to just should MM YY
On Tue, 17 Feb 2009 11:12:16 +0000, Bill wrote:
Hi All, I need a date field to just show the Month and Year. I'm not precious about the exact format but the problem is that I have entered information into a text field as just (for example) June 2009, but I now need to do comparisons based on that field which I had not foreseen at the outset. Is there anyway to display a date as I need please. Ta. Bill. You can use the format property on TextBoxes to *display* a date any way you like, but you must *store* a full date (year, month, day, hour, minute, and second). In most cases if you don't supply all values during data entry some defaults are assumed. For example not entering any time will give you a default of midnight. Not entering a year will (I think) default to the current year. Not entering the day will default to the first of the month. Of course if you are entering numeric values and don't supply all of them then Access will decide whether the number you omitted was the day, the month, or the year, and that decision might not be what you intended. -- Rick Brandt, Microsoft Access MVP Email (as appropriate) to... RBrandt at Hunter dot com |
Thread Tools | |
Display Modes | |
|
|