#1
|
||||
|
||||
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 |
Tags |
fail, incorrect, toggle |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Displayed date not showing correct format | trevorc | Excel | 2 | 01-13-2022 01:28 AM |
Use Original Award Date or Mod Award Date For Date-Based Recurring Tasks | KBCasey27 | Project | 1 | 04-30-2021 12:22 AM |
Way to get date on each slide correct? | AZG | PowerPoint | 1 | 03-18-2015 07:20 AM |
Date format switch with If statement | sbarron76 | Mail Merge | 3 | 05-03-2013 06:23 AM |
Number and date formatting | dmarie123 | Word VBA | 5 | 02-28-2013 03:10 PM |