![]() |
#1
|
|||
|
|||
![]()
Hi All,
I have a Word Template that uses the CREATEDATE \@ "dd/MM/yyyy" \* MERGEFORMAT field code. I also have { Quote “1.{={CreateDate \@ "M"-1}.2000” \@MMM} which is supposed to subtract 1 from the creation date (MMM format) and put it alongside other text (e.g. xxx Total Monthly Cash Income, where xxx should be current month -1). As an example in Dec 2020, I got Nov Total Monthly Cash Income,when the document was created on the 15/12/2020. I create a new document on the 5/1/21, and I got Jan Total Monthly Cash Income, it should have been Dec. Can anyone explain why this is not working as anticipated? Basically, the month to be prefixed before the wording Total Monthly Cash Income, should always be the previous month. Had no problem from mid year 2020 onwards (when the template was created). Any help offered will be appreciated. |
|
![]() |
||||
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 |
![]() |
GregL | Mail Merge | 13 | 12-20-2018 12:08 AM |
![]() |
susanto_tm | Word | 10 | 11-05-2018 05:41 AM |
![]() |
Jesperben | Word | 2 | 07-16-2016 03:49 AM |
Wrong date with CreateDate | Blablub | Word | 0 | 02-18-2010 04:20 AM |