Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 05-03-2018, 11:26 AM
Begadoc Begadoc is offline Convert and split date fields Windows 10 Convert and split date fields Office 2016
Novice
Convert and split date fields
 
Join Date: Nov 2013
Location: NW England
Posts: 20
Begadoc is on a distinguished road
Default Convert and split date fields

I have a database of some 6000 plus church burial records. These have been recorded as a date field for day and month (e.g. 22-Jan) and a second field for year (e.g 1775) All this data, plus data in a lot of other fields, is being transferred to a new program, for which the data needs to be in 4 fields - field 1 = date in the format of DD/MM/YYYY, field 2 = DD, field 3 = MM and field 4 = YYYY.

For starters I tried using search and replace to change all( for example) -Feb to /02, but that fails to find any. I also tried to convert the date fields to text but that resulted in dates such as 17-Feb becoming 43148. Once I get past this issue I hope that search and replace and concatenating will allow me to create the other filelds.

Any pointers as to how to achieve this?
Reply With Quote
 

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
subtract date and time and convert to decimal hours ? DBenz Excel 5 01-26-2017 05:38 AM
Convert and split date fields Copying DNA from web and need to convert column date to ex: 11-15 JacMUr2 Excel 2 01-22-2016 03:36 AM
Convert csv document to excel, format date coba Excel Programming 3 01-07-2016 04:18 AM
Convert and split date fields Convert text to date format klllmmm Excel 5 11-16-2015 07:02 AM
Non-printing button to convert a date field to text Greengecko Word VBA 1 09-09-2014 09:40 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 10:22 AM.


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