Filemaker Pro Date and Time Calculations
#1
Scooby Regular
Thread Starter
Join Date: Mar 1999
Location: The Great White North
Posts: 25,080
Likes: 0
Received 0 Likes
on
0 Posts
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.
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.
Thread
Thread Starter
Forum
Replies
Last Post
Pro-Line Motorsport
Car Parts For Sale
0
27 September 2015 11:19 AM