![]() |
|
|
Thread Tools | Display Modes |
#2
|
||||
|
||||
![]()
As a workaround, you could change your LetterDate variable's format to numeric and store the dates in ISO format (ie YYYYMMDD). You could then use field coding to ensure the stored number is output in whatever date format you require, using a field coded as:
{QUOTE"{=MOD(MOD(DOCVARIABLE LetterDate,10000),100)}-{=INT(MOD(DOCVARIABLE LetterDate,10000)/100)}-{=INT(DOCVARIABLE LetterDate/10000)}" \@ "DDDD, DD MMMM YYYY"} With this approach, you can change the date switch around to whatever day, month & year order and format you prefer.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
Date format in excel vba | LaercioNB | Excel | 3 | 08-09-2013 06:33 AM |
![]() |
jassie | Excel | 1 | 03-28-2013 02:33 AM |
updating status date and actual duration | ketanco | Project | 5 | 01-27-2012 07:32 AM |
![]() |
borntorun75 | Mail Merge | 3 | 12-16-2011 06:28 AM |
MS Project able to import actual start and or actual finish date from Excel? | mhacker | Project | 0 | 04-26-2010 11:29 AM |