date calculations

Jay R. Ashworth jra at baylink.com
Wed Mar 23 12:59:23 PST 2005


On Wed, Mar 23, 2005 at 03:35:26PM -0500, kahlerjr at cox.net wrote:
> I am new to this site. I learned Filepro around 15 years ago, however,
> I have not used it for the last 5 years. My brain is EXTREMELY
> foggy....... Can someone tell me how to calculate the number of months
> that have passed since a certain date? I'm writing an input processing
> and am trying to calculate the number of months an individual has been
> employed with a company.

Well, this depends a little bit on what your definition of "months" is.

:-)

If you have the two dates in *system date edit* fields, you can simply
subtract one from the other, and that will give you days.  You could
then divide by 30.5, and that would get you very close.  If the +/- 1
is critical, then you're going to have to take the dates apart with
MID() and do one component at a time.

Cheers,
-- jra
-- 
Jay R. Ashworth                                                jra at baylink.com
Designer                          Baylink                             RFC 2100
Ashworth & Associates        The Things I Think                        '87 e24
St Petersburg FL USA      http://baylink.pitas.com             +1 727 647 1274

      If you can read this... thank a system adminstrator.  Or two.  --me


More information about the Filepro-list mailing list