<div>
Try this:<br />
<br />
FirstDay: DateSerial(Year([Invoice Date]), Month([Invoice Date]), 1)<br />
<br />
<br />
EDIT:<br />
<br />
Too slow.
</div>


Try this:

FirstDay: DateSerial(Year([Invoice Date]), Month([Invoice Date]), 1)


EDIT:

Too slow.

<div>
Perfect - thank you very much
</div>


<div>
<div class="content wysiwyg-content">
Dear Experts<br />
<br />
In an Access Query I need to be able to return the 1st day of the month from a field<br />
<br />
the field is [Invoice Date]<br />
<br />
so if [Invoice Date] = 15/10/2013 then the result should come out as 01/10/2013 etc. &nbsp;This needs to come out as a date rather than a formatted text field<br />
<br />
Can anybody help?<br />
<br />
Many thanks
</div>
</div>


Dear Experts

In an Access Query I need to be able to return the 1st day of the month from a field

the field is [Invoice Date]

so if [Invoice Date] = 15/10/2013 then the result should come out as 01/10/2013 etc.  This needs to come out as a date rather than a formatted text field

Can anybody help?

Many thanks

Get 1st day of 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.