PC Review


Reply
Thread Tools Rate Thread

Calculating the previous month in a date field

 
 
ram
Guest
Posts: n/a
 
      17th Feb 2008
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


 
Reply With Quote
 
 
 
 
macropod
Guest
Posts: n/a
 
      17th Feb 2008
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/show...?Number=249902
or
http://www.gmayor.com/downloads.htm#Third_party

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

"ram" <(E-Mail Removed)> wrote in message news:05EAC021-E62F-4A5E-80E7-(E-Mail Removed)...
> 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
>
>

 
Reply With Quote
 
ram
Guest
Posts: n/a
 
      17th Feb 2008
this information is just what I needed

Thank You

"macropod" wrote:

> 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/show...?Number=249902
> or
> http://www.gmayor.com/downloads.htm#Third_party
>
> Cheers
> --
> macropod
> [MVP - Microsoft Word]
> -------------------------
>
> "ram" <(E-Mail Removed)> wrote in message news:05EAC021-E62F-4A5E-80E7-(E-Mail Removed)...
> > 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
> >
> >

>

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Calculating field for Previous Processing Day David Microsoft Access Queries 1 3rd Feb 2010 10:00 PM
Calculating first day of a month for a date field Chuck W Microsoft Access 1 5th May 2009 07:36 PM
Pull Specific Data by Previous Month's Date (Date Entered via prom Vylent Fyre Microsoft Access Queries 1 25th Jan 2008 06:13 PM
Calculating recurring date in following month, calculating # days in that period Walterius Microsoft Excel Worksheet Functions 6 4th Jun 2005 11:21 PM
Re: Print Monthly Calendar and have Date Navigator show previous month and following month Jocelyn Fiorello [MVP - Outlook] Microsoft Outlook Calendar 0 3rd Mar 2004 06:04 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 10:53 AM.