Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 12-13-2021, 02:58 PM
neubs007 neubs007 is offline Date formatting on String field Windows 10 Date formatting on String field Office 2019
Novice
Date formatting on String field
 
Join Date: Oct 2021
Posts: 1
neubs007 is on a distinguished road
Default Date formatting on String field

Is there a way to apply date formatting to a string field? I don't have control of the data source but the string field contains dates. I was wondering if there is a way to cast the type in Word so I can provide the a date switch /@.
Reply With Quote
  #2  
Old 12-13-2021, 10:12 PM
gmayor's Avatar
gmayor gmayor is offline Date formatting on String field Windows 10 Date formatting on String field Office 2019
Expert
 
Join Date: Aug 2014
Posts: 4,101
gmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud of
Default

If the field actually contains a date (and only a date) a date formatting switch should work even if the field type is text. Without a switch the result should be formatted as in the data source.
__________________
Graham Mayor - MS MVP (Word) (2002-2019)
Visit my web site for more programming tips and ready made processes www.gmayor.com
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Extracting date, month & year from a text string without using date format Help Haha88 Excel 5 08-06-2021 01:19 PM
Date formatting on String field Date field - future date calculation + only business days neon4 Word 7 01-21-2016 02:21 PM
Excel pivot table with a DATE value field for some reason stops at a certain date angie450 Excel Programming 2 08-19-2014 08:50 AM
Adding text before a date merge field AND fomatting date as well NikkiR Mail Merge 1 08-06-2014 07:18 PM
Date field inserting merge date in blank field Lesley Mail Merge 5 09-30-2013 01:49 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 05:47 AM.


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