Solved

End of Month dates

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

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering 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

Suggested Solutions

Title # Comments Views Activity
FM - Reducing height of rows in 150% Table View 11 94
FM - Problem Printing Color from Filemaker 6 145
filemaker server 1 54
View container field on iPad with filemaker go 3 51
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…
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…
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 …
In an interesting question (https://www.experts-exchange.com/questions/29008360/) here at Experts Exchange, a member asked how to split a single image into multiple images. The primary usage for this is to place many photographs on a flatbed scanner…

837 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