CREATEDATE-1 gives wrong date.

		Microsoft Office Forums > Microsoft Word > Word
CREATEDATE-1 gives wrong date.

FAQ

Thread Tools

Display Modes

01-10-2021, 06:26 AM

PM1

Windows 10 CREATEDATE-1 gives wrong date.

Office 2013

Novice

Join Date: Sep 2020

Posts: 8

Charles,

Thanks you for your kind assistance.

In the end I used

Code:

{QUOTE{=MOD({DATE \@ M}+10,12)+1}/0 \@ MMMM}

to fullfill my requirement.

For anyone else who may be interested

Code:

For this month: {DATE \@ MMMM}
For next month: {QUOTE{=MOD({DATE \@ M}+12,12)+1}/0 \@ MMMM}
 For last month: {QUOTE{=MOD({DATE \@ M}+10,12)+1}/0 \@ MMMM}


To get just the 3 letter code for the month, replay MMMM with MMM

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Date is displayed in the wrong format	shawn.low@cox.net	Mail Merge	1	12-28-2019 02:17 AM
Field for date that I run the mail merge; not Date nor CreateDate	GregL	Mail Merge	13	12-20-2018 12:08 AM
Office 2016 for Mac keeps getting the wrong date for the automatic date	susanto_tm	Word	10	11-05-2018 05:41 AM
My file dates are wrong, can I use the date inside Word?	Jesperben	Word	2	07-16-2016 03:49 AM
Wrong date with CreateDate	Blablub	Word	0	02-18-2010 04:20 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 08:31 PM.