Solved

End of Month dates

Posted on 2006-10-28
5
384 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
  • 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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
FileMaker Pro Reporting on relational database 4 452
Primary 1 74
Filemaker add-in for electronic billing and prescribing 6 82
sending mail from filemaker pro 10 5 45
Conversion Steps for merging and consolidating separate Filemaker files The following is a step-by-step guide for the process of consolidating two or more FileMaker files (version 7 and later) into a single file with multiple tables. Sometimes th…
Having just upgraded from Filemaker 11 to Filemaker 12 over the weekend, we thought we would add some tips for others making the same move.  In general, our installation went without incident. Please note that this is not a replacement for Chapter 5…
Internet Business Fax to Email Made Easy - With eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…
Hi friends,  in this video  I'll show you how new windows 10 user can learn the using of windows 10. Thank you.

911 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

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now