#1
|
|||
|
|||
Date format switch with If statement
Good afternoon. I am having an issue with a date format in an IF statement. The date format will not change to the French date format i have noted in the switch. The switch works for all standalone mergefields in the document but not within the IF statement. Here is the statement:
{IF{MERGEFIELD spouse_name}<> "" " Conjoint(e): {MERGEFIELD spouse_name } Date de naissance due (de la) conjoint(e): {MERGEFIELD spouse_dofb \@"d MMMM yyyy"}" ""} The IF statement works, if the spouse name is populated the field shows. And likewise doesn't if there is no spouse name. But the format of the date is not changing. Does the switch have to be placed somewhere else in the IF statement to work? Your help would greatly be appreciated! |
#2
|
||||
|
||||
Hi sbarron,
Your field construction looks OK, though there should be a space between the @ and the ".
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#3
|
|||
|
|||
Thanks for your response Paul. that was a typo on my part, as i had to type the code in the forum, i couldn't copy the text out of the word for some reason. So I do have the space, and the format still isn't working, so i am not sure where the issue lies as the date format shows correctly if the field is outside of the if statement. I will just have the staff update that one date manually until i can figure this out.
Thanks again for your assistance. Sean |
#4
|
||||
|
||||
Hi Sean,
Can you attach a document to a post containing the problem fields (delete anything sensitive)? You do this via the paperclip symbol on the 'Go Advanced' tab.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Timeline date format | mikeg | Project | 1 | 04-19-2013 06:26 AM |
excel 2010 to format a date | jassie | Excel | 1 | 03-28-2013 02:33 AM |
MS Query date format | remigio | Word | 3 | 08-21-2012 10:54 PM |
date format | gsrikanth | Excel | 1 | 12-28-2011 05:06 AM |
Mail merge will not format date field generated by Excel IF statement | borntorun75 | Mail Merge | 3 | 12-16-2011 06:28 AM |