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
Hello All
I have imported some data that has a date field in the format yyyymmdd. The rest of my database has dates as ddmmyyyy, so I don't want to change the setting in control pannel. I'm sure there must be an easy way of converting the field in my imported data to ddmmyyyy format but I can't seem to get it, so if anyone can help I would be extremely grateful. Thanks Les |
#2
|
|||
|
|||
G'morning, Leslie
Check the DateSerial() function if you want to convert the data to a date/time value. You can use the Left(), Mid() and Right() functions to "extract" the 'dd', 'mm', and 'yyyy' components. When you say your database has dates as ddmmyyyy, do you mean you literally are storing a text-type field with that structure, or are you using that format to display your date/time field values? -- Good luck Jeff Boyce Access MVP |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
i cant change the format of the date when referencing another cell | Brian | Worksheet Functions | 3 | September 29th, 2004 05:02 AM |
Date Format | Aurora | Running & Setting Up Queries | 1 | September 21st, 2004 03:55 PM |
Date Format | Date Formating Problem | Database Design | 3 | August 16th, 2004 06:41 PM |
Date Dilema! | Kagsy | General Discussion | 8 | July 13th, 2004 03:45 AM |
Pivot Table - Format of Date Field | Peo Sjoblom | Worksheet Functions | 0 | February 3rd, 2004 07:20 PM |