Word: Transpose SQL Dates

Today I worked out how to transpose SQL dates (copied from SQL Server) in Microsoft Word:

Bring up the Find and Replace dialog box. Enter the following:

Find what:

([0-9]{4})-([0-9]{2})-([0-9]{2}) ([0-9]{2}):([0-9]{2}):([0-9]{2}).000

Replace with:

\3/\2/\1

And enable “Use wildcards”

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.