Solution / Sample File Using FMP 7 native Time, Date & TimeStamp Functions

Description: All this is probably nothing special if You ever took time to look at this functions before.

Specially if you understood FMP counts Dates internally as days and Time and TimeStamps as seconds.

If You never looked before this small sample file could give You a faster insight on how to calculate with this functions.

the sample file shows how to calculate

Time difference

Date difference

and

TimeStamp difference

same principe can be used to add or subtract this kind of “data”.

It was less my wish to make it very elegant, than to make it understandable and use my own learning file for others

Critic & Suggestions welcome Ohgo_Ohgo

Working Under:

Solution Status: Beta

Pre-requisites: FM 7

Author(s): Ohgo_Ohgo

Date: 01/22/07

Credits: inspired by Field description article at http://www.samspublishing.com/

Instructions / Other Info: open and play with the Start and Stop field data to get a better feeling.

One advantage is that all month and year information is real to the calender not 30 days / month or 364 days / year etc.

Disclaimer:

FM Forums does not endorse or warrantee these files are fit for any particular purpose. Do not post or distribute files without written approval from the copyright owner. All files are deemed public domain unless otherwise indictated. Please backup every file that you intend to modify.

DateTimeStamp.zip

Edited January 26, 200718 yr by Guest
changed subject to correct allignment

WARNING ? THE ABOVE POST HAS A 1-2-3 DAYS ERROR!! SORRY I WAS WRONG

My calculation wrongly forgot to realise that days difference is a different number of months and days depending in what month of the year they are !