Question about Get Date function

[mrswombat]

Hello,

I currently have the following calculation: If (Item Received = "1"; Get (CurrentDate)), i.e. when I click a checkbox, the field with this calculation displays the current date.

Is it possible to modify this calculation so that the date I get when I click the checkbox is the last day of the current month? For example, I check the box on May 3, 2012 and the field displays "May 31, 2012." Thank you!

[Vaughan]

The Date() function has the property that the 0th day of the month is the last day of the previous month. So the calc would be:

Date( Month( Get( CurrentDate ) ) + 1 ; 0 ; Year( Get( CurrentDate ) ) )

[mrswombat]

Thank you so much Vaughan!