| Home | Forums | Reviews | Articles | Register |
 |
| Thread Tools | Rate Thread |
|
Guest
Posts: n/a
|
|
|
|
||
|
|
| |
|
Guest
Posts: n/a
|
|
|
|
|
||
|
|
| |
|
Guest
Posts: n/a
|
"Marshall Barton" <(E-Mail Removed)> wrote in message
news  (E-Mail Removed)...> rml wrote: > >>How can I make the following code convert the date portion to dd/mm/yy >>instead of the standard mm/dd/yy? >> >>= Trim([CreateDate] & " / " & [Tech]) > > > This is different from your other formatting question. > Here, you need to use the Format function: > > =Trim(Format(CreateDate, "ss/mm/yy") & " / " & [Tech]) Slight typo. It should be =Trim(Format(CreateDate, "dd/mm/yy") & " / " & [Tech]) -- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele (no private e-mails, please) |
|
|
|
|
|||
|
|
| |
|
| Thread Tools | |
| Rate This Thread | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Need help with converting CUSTOM format/TEXT format to DATE format | Deo Cleto | Microsoft Excel Worksheet Functions | 6 | 2nd Jun 2009 08:14 PM |
| Code Date Format Depending on Computer format | =?Utf-8?B?TXlyaWFt?= | Microsoft Excel Misc | 0 | 17th Jul 2007 03:26 PM |
| i have two date fileds Opend date Due date, can i set default on due date so, its always = to open date on my data entry form1 Urgent | Mike Saifie | Microsoft Access Form Coding | 1 | 9th Mar 2006 02:08 AM |
| code to convert date from TEXT format (03-02) to DATE format (200203) | Gauthier | Microsoft Excel Programming | 0 | 22nd Sep 2004 03:26 PM |
| Change a date in text format xx.xx.20xx to a recognised date format | concatenator | Microsoft Excel Programming | 1 | 25th Nov 2003 12:33 AM |
