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