MS Office 2010 - Word Macro

[G8T3R]

I am a novice at this and I have searched and searched over the last week trying to figure out a fix to this.

I'm trying to create a Word Macro to remove time from date:

This occurs in 4 different cells.

Cell in Word shows: 05/04/2016 10:00:00

I just need the date to show without the time.

Looking for a code that will make this happen.

Code that I have used for other issues looks something like this, however, the below example is what I'm trying to accomplish:
________________________________________________

Sub TIME()
'
' TIME Macro
'

With Selection.Find

.ClearFormatting
.Text = "??:??:??"
.Replacement.ClearFormatting
.Replacement.Text = ""
.Execute Replace:=wdReplaceAll, Forward:=True, _
Wrap:=wdFindContinue


End With

End Sub
________________________________________________

Any help would be greatly appreciated!
:banghead:

 

[Ranger4]

Hi & welcome to the Forum.

Instead of using a macro for adding the date you can use Alt+Shift+D instead.

This website may also help you as well.

How to Add the Date and Time to a Word 2010 Document - For Dummies

 

[G8T3R]

Hey,

We have a form that we created that pulls 3 different dates, in which something has occurred.
We created this form from a preconfigured XSD file.

This XSD file is configured to pull data from a SQL Database.

We need only the date to show up, not the time.

So we trying to figure out a quick fix to this to only show the date.

 

[Ranger4]

Sorry, I can't help you with that.

Perhaps someone else will drop & help.