<div>
HI matthewspatrick<br />
Thank you does excatly what I need it to do<br />
<br />
cheers
</div>


HI matthewspatrick
Thank you does excatly what I need it to do

cheers

<div>
<br />
assuming your month/year variable is xVar<br />
<br />
<br />
LastDay=dateserial(Int(&quot;20<wbr />&quot; &amp;&nbsp;split(xVar,&quot;/&quot;)(1),Int(spl<wbr />it(xVar,&quot;/<wbr />&quot;)(0) + 1,0)
</div>



assuming your month/year variable is xVar


LastDay=dateserial(Int("20" & split(xVar,"/")(1),Int(split(xVar,"/")(0) + 1,0)

<div>
<div class="content wysiwyg-content">
<br />
Hi Experts<br />
I need to use vba code to determine the end of month date given the month and year<br />
example: &nbsp;09/10 &nbsp;is 30/09/2010 &nbsp; or 10/10 is 31/10/10.<br />
<br />
<br />
Thanks
</div>
</div>



Hi Experts
I need to use vba code to determine the end of month date given the month and year
example:  09/10  is 30/09/2010   or 10/10 is 31/10/10.


Thanks

vba code to determine the full end of month date given the month and year

Programming includes both the specifics of the language you’re using, like Visual Basic, .NET, Java and others, but also the best practices in user experience and interfaces and the management of projects, version control and development. Other programming topics are related to web and cloud development and system and hardware programming.

Programming

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.