I am merging a field from excel with this formula "=IF(AP20<DATE(2020,4,1),DATE(2020,4,1),AP20)" this cell shows 1/4/2020, however when merge to word, it shows 04012020, I have added this to the merge field already { MERGEFIELD Date_of_join_X \ @ddMMyyyy } , howcome the month and date is the wrong way round?
Thanks!
Thanks!