Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 04-30-2024, 03:12 AM
Chris_010101's Avatar
Chris_010101 Chris_010101 is offline Date pulling through as number DESPITE correct date switch Windows 11 Date pulling through as number DESPITE correct date switch Office 2021
Novice
Date pulling through as number DESPITE correct date switch
 
Join Date: Sep 2022
Posts: 2
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
Reply

Tags
fail, incorrect, toggle



Similar Threads
Thread Thread Starter Forum Replies Last Post
Date pulling through as number DESPITE correct date switch 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
Date pulling through as number DESPITE correct date switch Way to get date on each slide correct? AZG PowerPoint 1 03-18-2015 07:20 AM
Date pulling through as number DESPITE correct date switch Date format switch with If statement sbarron76 Mail Merge 3 05-03-2013 06:23 AM
Date pulling through as number DESPITE correct date switch Number and date formatting dmarie123 Word VBA 5 02-28-2013 03:10 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:24 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft