71.8 F
Friday, June 2, 2023

FileMaker Date Formats & Functions


An instructional video about FileMaker Date Formats and date functions. This includes time and timestamps as well. If you’d like to know as much as possible about how FileMaker stores and interacts with dates and times then you’ll likely find some great information in this video.

00:00 – Start
00:30 – Quick overview
01:07 – Date/Time/Timestamp Fundamentals
02:02 – When you want date vs time vs timestamp
03:32 – How dates/times are really stored
08:20 – The atomic units of dates & times
10:20 – Formatting FileMaker dates & times
12:13 – The two uses of time in FileMaker
15:56 – Display formats for dates & times
19:03 – Understanding UTC time
27:00 – Date & Time Custom Functions for FileMaker
32:10 – Calculating a person’s age in FileMaker
34:12 – Calculating time between two dates
36:37 – Calculating a day in the future
38:15 – Calculating total months elapsed
39:03 – Calculating Date of Month in FileMaker
42:01 – Quick Overview – Contents

Link to file download

#filemakerdates #filemaker

ISO FileMaker Magazine
ISO FileMaker Magazinehttps://www.filemakermagazine.com/
With over two decades of experience with FileMaker Pro, and a strong familiarity with the available resources in the FileMaker development community, we would like to first understand your specific needs and then make a sound recommendation.

Share post:

crm erp
crm erp


More like this

5 Ways To Maximize The Free Tier Of Claris Connect

A lot of changes have been happening recently at...

DevOps Essentials: Defining Your Pipeline

In this first video of the DevOps Essentials series,...