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
|
|||
|
|||
Date Format
I have an import file (from Excel) that has a date in the following format:
yyyymmdd I have created an input mask that adds a forward slash / to the date when I do the import and thus creating yyyy/mm/dd I would like to have it as mm/dd/yyyy either in the table (preferred) or when I open the form and pull the data through a query have the date format as mm/dd/yyyy. Any suggestions on an expression I can use in the query? On the form I have a combo box that the user selects a number and then a list box is populated with all of the data (6 different fields) related to that particular number. Even though the input mask on the table improves the date format, when I open the form the date reverts back to the yyyymmdd format, no slashes. Thanks, John |
#2
|
|||
|
|||
Date Format
|
#3
|
|||
|
|||
Thanks Tim!
The field that imports into the table shows up in the table as a text field. I have everything set up in a form to pull the data I need. I just wanted it to show up in the form as a an actual date format (mm/dd/yyyy) instead of the text format of (yyyymmdd). What do you mean below by "Normalized"? On the form I have a combo box that the user selects a number and then a list box is populated with all of the data (6 different fields) related to that particular number. Don't sound very Normalised... :-( Thanks, John |
#4
|
|||
|
|||
"=?Utf-8?B?Sm9obiBEYWlseQ==?=" wrote
in : What do you mean below by "Normalized"? Among other things, it means Holding Exactly One Piece of Information in One Field -- in other words not six bits. Six dates ought to be held in six fields, or, more probably, in one field in six records of another table. Normalisation is a design process that is based on Relational Theory, which in turn is based on Set Theory, which you probably covered in school. R is the basis of the current generation of (relational) database systems: if you want to do anything useful with Access, you really do need some working knowledge of the background. (That is the short version: the long story fills entire textbooks and postgrad courses!) All the best Tim F |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Date Dilema! | Kagsy | General Discussion | 8 | July 13th, 2004 03:45 AM |
Date format for Track Changes | Stuart K | New Users | 1 | June 13th, 2004 11:09 AM |
Pivot Table - Format of Date Field | Peo Sjoblom | Worksheet Functions | 0 | February 3rd, 2004 07:20 PM |
Does date fall between two ranges? | MR | Worksheet Functions | 4 | January 14th, 2004 04:08 PM |
Changing date format to text only | Worksheet Functions | 0 | January 1st, 2004 07:37 AM |