Setting Dates in Word - first and last day of previous month

[Barb Reinhardt]

Can someone direct me to some code to calculate the first and last day of
the previous month to be used in an Invoice?

Thanks in advance,
Barb Reinhardt

 

[macropod]

Hi Barb,

For a field-code solution, download the Word document at:
www.wopr.com/cgi-bin/w3t/showthreaded.pl?Number=249902
(url all one line)
That document contains a tutorial for doing a wide range of date/time
calculations in Word, including some of the kind you're after.

If you need it, there are macro-based solutions also that I'm sure one of
the other contributors here could post.

Cheers

 

[Barb Reinhardt]

I believe I looked at that yesterday and had limited success. I can't seem
to open it today. Are there any tutorials for field codes and how to do
calculations, etc. with them? I haven't been able to find any.

Thanks for your assistance.

 

[Barb Reinhardt]

Let me ask a couple of more specific questions. I want to create several
date fields. They need to work for the following two circumstances.

1) If the CREATE DATE is any day in January 2005, how do I create the
following:
1st field: First date of previous month in format 12/1/2004
2nd field: Last date of previous month in format 12/31/2004
3rd field: Last date of prevous month in format December 31, 2004
4th field: Year portion of previous month in format 2004.
2) If the CREATE DATE is December 2004, how do I create:
1st field: First date of previous month in format 11/1/2004
2nd field: Last date of previous month in format 11/31/2004
3rd field: Last date of prevous month in format November 30, 2004
4th field: Year portion of previous month in format 2004.

 

[Barb Reinhardt]

I have the following as field codes

{ =IF( { CREATEDATE \@ "MM" } = 01 { CREATEDATE \@ "yyyy" } { = { CREATEDATE \@ "yyyy" }+1 \# "0000"} ) }



Everything in RED is working, but I can't get the IF statement to work. What am I doing wrong?

 

[Charles Kenyon]

IF does not use parentheses in Word

{ =IF { CREATEDATE \@ "MM" } = 01 { CREATEDATE \@ "yyyy" } { = { CREATEDATE
\@ "yyyy" }+1 \# "0000"} }

For additional samples of IF statements in dates look at
http://addbalance.com/word/datefields2.htm.


I have the following as field codes

{ =IF( { CREATEDATE \@ "MM" } = 01 { CREATEDATE \@ "yyyy" } { = { CREATEDATE
\@ "yyyy" }+1 \# "0000"} ) }



Everything in RED is working, but I can't get the IF statement to work.
What am I doing wrong?

 

[Graham Mayor]

I think you are trying to do the following:

{ IF { CREATEDATE \@ "MM" } = "01" "{ CREATEDATE \@ "yyyy" }" "{ =({
CREATEDATE \@ "yyyy" }+1) \# "0000" }"}

ie for January you want this year, for other months next year

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>




I have the following as field codes

{ =IF( { CREATEDATE \@ "MM" } = 01 { CREATEDATE \@ "yyyy" } { = { CREATEDATE
\@ "yyyy" }+1 \# "0000"} ) }

Everything in RED is working, but I can't get the IF statement to work.
What am I doing wrong?

 

[Barb Reinhardt]

I've tried both of them and I still get a syntax error.

 

[Barb Reinhardt]

I have resolved some of the field codes and I get this:

{ =IF 12 = "01" "2004" "2005"}



But when I try to update the field, I get this:



!Syntax Error, 12

 

[Charles Kenyon]

If in doubt, add quotation marks. Try
{ =IF "12" = "01" "2004" "2005"}

I am assuming that the 12 is generated by some other field. I haven't been
following the entire thread.

 

[Graham Mayor]

It works fine here - are you setting all the field boundaries {} using
CTRL+F9 or are you simply typing them

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

 

[Graham Mayor]

The = sign is not required in front of the IF

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

 

[Barb Reinhardt]

I had to add commas to get it to work. I reviewed some of the examples
from a link posted by macropod and went from there. Thanks for your help
on this one.