<div>
The last day of the previous month:<br />
DateSerial(Year(Date()), Month(Date()),0)<br />
<br />
mx
</div>


The last day of the previous month:
DateSerial(Year(Date()), Month(Date()),0)

mx

<div>
And this should come in handy:<br />
<br />
Functions for calculating and for displaying Date/Time values in Access:<br />
<br />
<a href="http://support.microsoft.com/kb/210604" rel="ugc">http://support.microsoft.com/kb/210604</a><br />
<br />
mx
</div>


And this should come in handy:

Functions for calculating and for displaying Date/Time values in Access:

http://support.microsoft.com/kb/210604 [http://support.microsoft.com/kb/210604]

mx

<div>
First day of current month can be found with DateSerial(Year(Date()), Month(Date()), 1)<br />
<br />
Last day of previous month is DATEAD that -1<br />
<br />
Kelvin
</div>


First day of current month can be found with DateSerial(Year(Date()), Month(Date()), 1)

Last day of previous month is DATEAD that -1

Kelvin

<div>
Thank you both, first for putting in the thread like that, Joe and the explanation HNASR. &nbsp;Working Great.
</div>


Thank you both, first for putting in the thread like that, Joe and the explanation HNASR.  Working Great.

<div>
<div class="content wysiwyg-content">
How do I alter the below to select last day of previous month rather than current date?<br />
<br />
0-365: Sum(((IIf([ORDER_DATE]&gt;=Da<wbr />te()-365,[<wbr />AMOUNT_BIL<wbr />LED],0))))<wbr />
</div>
</div>


How do I alter the below to select last day of previous month rather than current date?

0-365: Sum(((IIf([ORDER_DATE]>=Date()-365,[AMOUNT_BILLED],0))))

How do I select last date of previous month?

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.

Microsoft Access

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.