View Single Post
 
Old 04-30-2024, 03:12 AM
Chris_010101's Avatar
Chris_010101 Chris_010101 is offline Windows 11 Office 2021
Novice
 
Join Date: Sep 2022
Posts: 4
Chris_010101 is on a distinguished road
Default Date pulling through as number DESPITE correct date switch

Hello,

I am having an issue where a date is pulling through to a mail merge as a number, despite the correct toggle switch being used.

The switch being used is: { MERGEFILED SLA_Expiry \@ "d MMMM yyyy"}

But the result is: 45615

Could it be that the date is being pulled from a formula in the data source?

=IF(OR(ISBLANK(B3), ISBLANK(C3)), "", EDATE(B3, C3)-1)

If so, can this be fixed? I've never seen this before, it's always just worked. I've tried amending cell formatting and no luck

Thanks

Edit: This only happens when the data source is open

Last edited by Chris_010101; 04-30-2024 at 03:14 AM. Reason: Add information
Reply With Quote