Home | Tips | Library | Other Authors | Other WP Sites | Writer's Links | Contact | Site Map | Donate

Barry MacDonnell's
Toolbox for WordPerfect

Macros, tips, and templates for Corel® WordPerfect® for Windows®
© Copyright 1996-2017 by Barry MacDonnell. All Rights Reserved.

Page updated Jan 18, 2014

TXT2DATE - Numerical text to date converter

Download TXT2DATE.ZIP (v2.05, 01/18/14; and v1.05, 9/18/01; ZIP file = 35,797 bytes)

Compatible with WordPerfect 8 and later versions

WordPerfect 11 users: See important information about using macros in the first release of WP11 (11.0.0.233) at the top of this page.

Downloading, Documentation, Modifications, and Support

A WordPerfect macro to convert all numerical dates — text strings (not date codes) in the format "01/01/01," "1/1/01," "1/1/2001," or similar — to static text strings in a format such as "January 1, 2001." Any one of eight conversion formats can be chosen from a menu, including "legal" dates such as "the 1st day of January, 2001."

Dates in the format MM/DD/YY from 01/01/00 to 12/31/29 are converted to dates between 2000-2029. Dates in the format MM/DD/YYYY will be converted to the specified year. (E.g., 1/1/00 will convert to January 1, 2000, while 1/1/1900 will convert to January 1, 1900.)

The macro's menu can be suppressed for speed, and/or default selections made, by making simple changes to the User Modification Area at the top of the macro's code. Please read the comments at the top for more information.

NOTES

Version 1.05 is also included (Txt2Date105.wcm) in the download file as a programmer's reference to using floating cells to convert text strings. However, v1.05 does not work reliably under WP8 (sorry). Delete the older version if you don't need it.