Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #2  
Old 09-30-2024, 07:02 PM
macropod's Avatar
macropod macropod is offline Convert data from string to date Windows 10 Convert data from string to date Office 2016
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,467
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

It shouldn't matter whether the data are coming through as strings - the date field switches (e.g. \@ "DDD D MMMM YYYY") should still be able to provide the required formatting - you don't need to convert the data to a Word DATE field (which wouldn't be possible anyway).
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Convert data from string to date Reading date from string ArviLaanemets Excel Programming 3 08-28-2024 07:19 AM
Date formatting on String field neubs007 Mail Merge 1 12-13-2021 10:12 PM
Extracting date, month & year from a text string without using date format Help Haha88 Excel 5 08-06-2021 01:19 PM
Microsoft Excel to extract date from another string Rajeshwar Excel 1 10-26-2016 09:57 AM
Convert data from string to date Convert numbers to a specific text string francis Excel 1 10-06-2011 01:43 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 09:15 PM.


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