Calculating the previous month in a date field

  • Thread starter Thread starter ram
  • Start date Start date
R

ram

Hi
Can someone help me calculate the previous month in a date field. the code
below calculates the month however i don't know how to format the
expression to display in date format

{={DATE \@ "MM"} -1}

i also tried using set month but received an error.



Thanks for any help
 
this information is just what I needed

Thank You

macropod said:
Hi ram,

To see how to do this and just about everything else you might want to do
with dates in Word, check out my Date Calc 'tutorial', at:
http://www.wopr.com/cgi-bin/w3t/showthreaded.pl?Number=249902
or
http://www.gmayor.com/downloads.htm#Third_party

Cheers
--
macropod
[MVP - Microsoft Word]
-------------------------

ram said:
Hi
Can someone help me calculate the previous month in a date field. the code
below calculates the month however i don't know how to format the
expression to display in date format

{={DATE \@ "MM"} -1}

i also tried using set month but received an error.



Thanks for any help
Click to expand...
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Unexpected result in date calculations 6
Help required on Tabulating monthly expenses for the Current Month,Previous Month and Month previous 12
Creating a date calculation with a text form field 2
Access Getting Month periods to show in ACCESS query as 0 when there is no data for the month 0
Advanced Word Formula w/ date 1
Previous Year in a Date Field 4
I want to calculate a date 1 year ahead of a date in a bookmark 1
Calculate date for one month previous? 3

Back
Top