Filemaker Pro Date and Time Calculations
 

I don't suppose anyone on here happens to be a bit handy when it comes to date and time calculations in filemaker?

The situation is that I've got various files which contain a value which is the date and time in seconds since 1st Jan 1904. Some files contain this as a negative value, others as a positive value.

I have an Excel calc that handles both:

IF(A1<0,DATE(50,1,1)+((2843274496+A1)/86400),(A1/86400))

You simply replace the A1 references to the cell containing the value, and it'll work out if it's neg or pos and then perform the correct calculation on it.

What I'm looking for is a similar thing for Filemaker Pro, as I want to import the files into filemaker rather than use Excel.

did a google and filemaker can use an abs function.

you'll always have a +ve number then

hth