![]() |
#1
|
|||
|
|||
![]()
This field code returns a date:
{ QUOTE { SET Delay -1 } { SET m { =MOD({ DATE \@ MM }+Delay+11;12)+1 } }{ SET y { =INT({ DATE \@ yyyy }+(Delay+{ DATE \@ M }-1)/12) } } “{ m }-{ y }” \@ “MMM/yy” } But, instead of "QUOTE" show the date, I need to set a variable with this date. How to set a variable instead of show the date? Something like (which does not works): { SET DateX { QUOTE { SET Delay -1 } { SET m { =MOD({ DATE \@ MM }+Delay+11;12)+1 } }{ SET y { =INT({ DATE \@ yyyy }+(Delay+{ DATE \@ M }-1)/12) } } “{ m }-{ y }” \@ “MMM/yy” } } So, if elsewhere in the document I want to see the date, I just insert a field: { DateX } Ps.: please move this topic to WORD , sorry. Thanks
__________________
Backup your original file before doing any modification. |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
I want to create a bar chart of multiple variable. Then I need to draw trend lin of those variable | shimulsiddiquee | Excel | 1 | 05-16-2017 07:39 AM |
![]() |
Cosmo | Word | 2 | 12-29-2015 11:54 AM |
Run Time Error '91': Object variable or With block variable not set using Catalogue Mailmerge | Berryblue | Mail Merge | 1 | 11-13-2014 05:36 PM |
![]() |
JUST ME | Word VBA | 4 | 03-25-2014 06:56 AM |
![]() |
tinfanide | Excel Programming | 2 | 06-10-2012 10:17 AM |