• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 412
  • Last Modified:

End of Month dates

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?
0
c0link
Asked:
c0link
  • 2
1 Solution
 
lesouefCommented:
there is no built-in function for yr pb, but you can achieve it this way:
latest date = 1st day of the current month - 1 day

filemakerwise, this is:

if Ddate is the date to calculate from:
Latest_date = Date ( Month ( Ddate ) ; 1 ; Year ( Ddate ) ) -1

The same way, you can achieve the end of the current month this way:
Latest_date = Date ( Month ( Ddate ) +1 ; 1 ; Year ( Ddate ) ) -1
0
 
c0linkAuthor Commented:
looks simple enough, let me work it through.
0
 
c0linkAuthor Commented:
I thought I had accepted the answer. I have no problem with this being credited to lesouef.
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now