<div>
If you just want the month, you can use:<br />
Month(Dateadd(month,-1,Inv<wbr />oiceDate))<wbr /><br />
You can then format it any way you want.<br />
You can also use (in VBA anyway):<br />
Format(Dateadd(month,-1,In<wbr />voiceDate)<wbr />,&quot;MMMM&quot;)
</div>


If you just want the month, you can use:
Month(Dateadd(month,-1,InvoiceDate))
You can then format it any way you want.
You can also use (in VBA anyway):
Format(Dateadd(month,-1,InvoiceDate),"MMMM")

<div>
Try this:<br />
<br />
Format(DateAdd(YourDate,&quot;m<wbr />&quot;, -1), &quot;mmmm, yyyy&quot;)
</div>


Try this:

Format(DateAdd(YourDate,"m", -1), "mmmm, yyyy")

<div>
To also show year, you can use the format with &quot;MMMM, yyyy&quot;
</div>


To also show year, you can use the format with "MMMM, yyyy"

<div>
I got the DateAdd arguments backwards in my comment.<br />
<br />
The syntax, as the others have is:<br />
<br />
DateAdd(Interval, Number,Date)
</div>


I got the DateAdd arguments backwards in my comment.

The syntax, as the others have is:

DateAdd(Interval, Number,Date)

<div>
<div class="content wysiwyg-content">
I would like to know if there is a function to calculates the month and the year for you based on a date in this format: &quot;mm/dd/yyyy&quot;. The month to derive should be the month of the invoice date -1. For example if the invoice date is <b>01/10/2012</b> then the period should show: <b>December, 2011</b>. Another example: when the invoice date is 12/12/2011 then period should be<b> November, 2011</b>, etc...<br />
<br />
Any help is most appreciated.
</div>
</div>


I would like to know if there is a function to calculates the month and the year for you based on a date in this format: "mm/dd/yyyy". The month to derive should be the month of the invoice date -1. For example if the invoice date is 01/10/2012 then the period should show: December, 2011. Another example: when the invoice date is 12/12/2011 then period should be November, 2011, etc...

Any help is most appreciated.

calculate period based on a date (invoice date)

Most development for the Microsoft platform is done utilizing the technologies supported by the.NET framework. Other development is done using Visual Basic for Applications (VBA) for programs like Access, Excel, Word and Outlook, with PowerShell for scripting, or with SQL for large databases.

Microsoft Development

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.