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
|