Vba Convert Date value from 8/7/19 to August 7, 2019

[zoog25]

Hello All,

Here is my situation, i'm using excel vba on a spreadsheet. All the values of column K are in mm/dd/yy ie (8/7/19). Now i have made a macro that take information from this sheets and fills a few word documents. My problem is that they now want the documents to display the full calendar date (ie August 7, 2019). How would i go about doing this. So far here is what i have

NOCdate = NOCws.Cells(Target, "K").Value

Wordapp.ActiveDocument.FormFields("TXCompletionDate").Result = NOCdate

How can i convert the date entered into NOCdate to the format Month Date, Year or August 7, 2019.

Thank you.

 

[crystalneedshelpplzthnx]

If it is possible to use a 'helper' column, I'd reformat the date in another column =text(Ref, "Mmmm D, YYYY") and have your macro reference the new column.
Ref = the current date column

If a helper column is not an option, the current column is a formula and adjusting the current column would not impact any other formula, you could use the same formula but
Ref = current formula

HTH

 

[Norie]

Try this.

Wordapp.ActiveDocument.FormFields("TXCompletionDate").Result = Format(NOCdate, "mmmm dd, yyyy")

 

[zoog25]

Thank you Norie, It worked perfectly.