How to validate date in mail merge

Thanks for your reply.

I am not able to point what you said.

Can you give me a picture guide?

Insert the mergefield that contains the date into your mail merge main document before any other mergefield.  Assuming that the field name is Date, it will look like

«Date»

Select that field and then hold down the CTRL key and press the F9 key which will result in the field being enclosed in a pair of field delimiters as shown below

{ «Date» }

Then Hold down the ALT key and press the F9 key to toggle on the display of the field codes, which will result in the following being displayed

{ { MERGEFIELD Date } }

Then place the selection between the two } } after the word Date and hold down the CTRL key and press F9 again so that you have

{ { MERGEFIELD Date } { } }

Now insert the balance of the text that Graham detailed in the appropriate places.  Make sure that you have a space either side of the <>

Finally Hold down the ALT Key and press F9 again to toggle off the display of the field codes.

Do not be alarmed by the fact that you no longer see the mergefield or any of the text that you entered.  The field construction is still there and when you execute the merge, it will cause the records that do not meet the criteria to be skipped.