<div>
looks simple enough, let me work it through.
</div>


looks simple enough, let me work it through.

<div>
I thought I had accepted the answer. I have no problem with this being credited to lesouef.
</div>


I thought I had accepted the answer. I have no problem with this being credited to lesouef.

<div>
<div class="content wysiwyg-content">
I am trying to calculate the end date of each month using the field Latest_Date. I have tried using the calculation<br />
Date(Month(Latest_Date)-1;<wbr />Day(Latest<wbr />_Date);Yea<wbr />r(Latest_D<wbr />ate))<br />
<br />
However, if Latest_Date is 30th June 2006, the date it will give me is 30th May 2006. What I want is to go back on a calendar month basis so that the returned value would be 31st May 2006, 30th April 2006, etc. Does Filemaker Pro have this date feature? If so how do I go about it?
</div>
</div>


I am trying to calculate the end date of each month using the field Latest_Date. I have tried using the calculation
Date(Month(Latest_Date)-1;Day(Latest_Date);Year(Latest_Date))

However, if Latest_Date is 30th June 2006, the date it will give me is 30th May 2006. What I want is to go back on a calendar month basis so that the returned value would be 31st May 2006, 30th April 2006, etc. Does Filemaker Pro have this date feature? If so how do I go about it?

End of Month dates

FileMaker Pro is a cross-platform relational database application that integrates a database engine with a graphical user interface (GUI) and security features, allowing users to modify the database by dragging new elements into layouts, screens, or forms. FileMaker evolved from a DOS application, but since 1992 has been available for Microsoft Windows and Mac OS, and can be used in a cross-platform environment.