If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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? |
Thread Tools | |
Display Modes | |
|
|