Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
future date problem
You all know the problem:
I want a date that is some days ahead (or behind) the date in my merge field. I have spent hours now messing around with the code from the following 2 sites: Charles Kenyon's ( http://addbalance.com/word/datefields2.htm) and Macropod's (http://www.wopr.com/cgi-bin/w3t/show...?Number=249902) They use very different methods to solve the problem, however NEITHER of them are giving me the right answer! I have been using the DATE function for input (no merge involved) and a delay of 14 days. For today's date (2/19/09) they BOTH give me the wrong answer! One gives me Feb 33, 2009 and the other gives me May 3, 2009. Interestingly, they both give right answer when I use a 7 day delay. Help anyone? |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
future date problem
You have overlooked the following part of the Introductory Notes to
Macropod's methods: Quote Date input/output formats Many date fields in this document are region-dependent and are coded to work on systems using day-month-year regional settings. For system using month-day-year regional settings, obtaining a correctly result is as simple as changing the order of the embedded fields coded as '{dd}-{mm}-{yy}'to '{mm}-{dd}-{yy}'. Included in this document is a macro to automate the change. Changing the order shouldn't be necessary for systems using day-month-year settings; for those using month-day-year settings, it's a once-only change. To run the macro, Press Alt-F8 and select the macro named 'SwapDayMonthCodes', then click 'Run'. Unquote -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP "aardvick" wrote in message ... You all know the problem: I want a date that is some days ahead (or behind) the date in my merge field. I have spent hours now messing around with the code from the following 2 sites: Charles Kenyon's ( http://addbalance.com/word/datefields2.htm) and Macropod's (http://www.wopr.com/cgi-bin/w3t/show...?Number=249902) They use very different methods to solve the problem, however NEITHER of them are giving me the right answer! I have been using the DATE function for input (no merge involved) and a delay of 14 days. For today's date (2/19/09) they BOTH give me the wrong answer! One gives me Feb 33, 2009 and the other gives me May 3, 2009. Interestingly, they both give right answer when I use a 7 day delay. Help anyone? |
#3
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
future date problem
That did it. Thanks a million! -V
"Doug Robbins - Word MVP" wrote: You have overlooked the following part of the Introductory Notes to Macropod's methods: Quote Date input/output formats Many date fields in this document are region-dependent and are coded to work on systems using day-month-year regional settings. For system using month-day-year regional settings, obtaining a correctly result is as simple as changing the order of the embedded fields coded as '{dd}-{mm}-{yy}'to '{mm}-{dd}-{yy}'. Included in this document is a macro to automate the change. Changing the order shouldn't be necessary for systems using day-month-year settings; for those using month-day-year settings, it's a once-only change. To run the macro, Press Alt-F8 and select the macro named 'SwapDayMonthCodes', then click 'Run'. Unquote -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP "aardvick" wrote in message ... You all know the problem: I want a date that is some days ahead (or behind) the date in my merge field. I have spent hours now messing around with the code from the following 2 sites: Charles Kenyon's ( http://addbalance.com/word/datefields2.htm) and Macropod's (http://www.wopr.com/cgi-bin/w3t/show...?Number=249902) They use very different methods to solve the problem, however NEITHER of them are giving me the right answer! I have been using the DATE function for input (no merge involved) and a delay of 14 days. For today's date (2/19/09) they BOTH give me the wrong answer! One gives me Feb 33, 2009 and the other gives me May 3, 2009. Interestingly, they both give right answer when I use a 7 day delay. Help anyone? |
#4
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
future date problem
When all else fails RTM!
-- Cheers macropod [MVP - Microsoft Word] "aardvick" wrote in message ... That did it. Thanks a million! -V "Doug Robbins - Word MVP" wrote: You have overlooked the following part of the Introductory Notes to Macropod's methods: Quote Date input/output formats Many date fields in this document are region-dependent and are coded to work on systems using day-month-year regional settings. For system using month-day-year regional settings, obtaining a correctly result is as simple as changing the order of the embedded fields coded as '{dd}-{mm}-{yy}'to '{mm}-{dd}-{yy}'. Included in this document is a macro to automate the change. Changing the order shouldn't be necessary for systems using day-month-year settings; for those using month-day-year settings, it's a once-only change. To run the macro, Press Alt-F8 and select the macro named 'SwapDayMonthCodes', then click 'Run'. Unquote -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP "aardvick" wrote in message ... You all know the problem: I want a date that is some days ahead (or behind) the date in my merge field. I have spent hours now messing around with the code from the following 2 sites: Charles Kenyon's ( http://addbalance.com/word/datefields2.htm) and Macropod's (http://www.wopr.com/cgi-bin/w3t/show...?Number=249902) They use very different methods to solve the problem, however NEITHER of them are giving me the right answer! I have been using the DATE function for input (no merge involved) and a delay of 14 days. For today's date (2/19/09) they BOTH give me the wrong answer! One gives me Feb 33, 2009 and the other gives me May 3, 2009. Interestingly, they both give right answer when I use a 7 day delay. Help anyone? |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Future Date/Print Date Fields | Microsoft Word Help | |||
Display a future date calculated from todays date | Microsoft Word Help | |||
How to get a date merge field to show a date 60 days in the future | Mailmerge | |||
How to insert future date based on current date plus 14 days | Microsoft Word Help | |||
How do i update a word document date field with a future date | Microsoft Word Help |