Microsoft Word Formula: IF Statement

[WPCMS]

I am trying to create a formula for a Word document that shows only the new start dates for our services. The table will have rows of types of services. Each time a service changes we print a letter of all of the services. All of the services in our system have start dates but we want the service with the new change to only show the new start date.

I was trying to create a formula that says

If the start date is greater than today, then show, else null

or

If the start date is equal to current month, then show, else null

Please let me know how I should set this up as our users are merging the doc then they have to manually delete the old service start days.

Thank you in advance.

 

[macropod]

Hi WPCMS,

Assuming your start date is bookmarked 'StartDate':
{IF{StartDate \@ YYYYMMDD}> {Date \@ YYYYMMDD} "Text to Show"}

You also mention merging, so for a mailmerge:
{IF{MERGEFIELD StartDate \@ YYYYMMDD}> {Date \@ YYYYMMDD} "Text to Show"}

For month-level resolution, simply delete the 'DD' parts of the expressions.


Cheers
[MS MVP - Word]

 

[WPCMS]

I am not sure what you mean about bookmarked.

I ended up with

IF <<Start_date>> > <<TODAY>> "<<Start_Date>>" ""

But this does not work.

Can you tell me what I need to do with this formula to make it work?

Thanks

 

[macropod]

Hi WPCMS,

You need to input the formula as:
{IF{MERGEFIELD Start_Date \@ YYYYMMDD}> {Date \@ YYYYMMDD} {MERGEFIELD Start_Date ##}}
using Ctrl-F9 to create the field braces.

Note: where I've got the ##, you should insert the appropriate field switch to format the date as required. Possible date formatting switches include:
. \@ "dddd, d MMMM yyyy";
. \@ "ddd, d MMMM yyyy";
. \@ "d MMM yyyy";
. \@ "dd/MMM/yyyy";
. \@ "d-MM-yy";
Note: Note: you can swap the d, M, y expressions around, but you must use uppercase 'M's for months (lowercase 'm's are for minutes). You can also use 'D's for days and 'Y's for years.




Cheers
[MS MVP - Word]