Two ways to add a date to a character field:
| Replace all date with CMONTH(DATE())+" "+ALLT(STR(DAY(DATE())))+", "+ALLT(STR(YEAR(DATE()))) |
This will give you December 25, 2030
| Replace all date with DTOC(date()) |
This will give you 12/25/2030
M.S., Mt. Vernon, ILWe have over 200 vendors we work with on a daily basis and (the AccuZIP6 techs) are the most knowledgable, helpful group of folks I have worked with, always willing to go out of the way to help. As owner and GM of a Print and Mail Shop I admire the dedication these folks have in making sure we are satisfied. I also appreciate the fact that a human answers the phone.
