Solved

End of Month dates

Posted on 2006-10-28
5
394 Views
Last Modified: 2010-04-27
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
Comment
Question by:c0link
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
5 Comments
 
LVL 28

Accepted Solution

by:
lesouef earned 250 total points
ID: 17826331
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
 

Author Comment

by:c0link
ID: 17828789
looks simple enough, let me work it through.
0
 

Author Comment

by:c0link
ID: 18024473
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.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Pop up windows can be a useful feature of any Filemaker database.  Though best used sparingly, they can be employed in a multitude of different ways, for example;  as a splash screen at login, during scripted processes to control user input, as pick…
Problem: You have a hosted FileMaker database and users are tired of having to use Open Remote or Open Recent to access the database. They say, "can't you just give us something to double-click on rather than have to go through those dialogs?" An…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…

732 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question