FileMaker Overview: Date & Time Functions

Knowing how FileMaker's Date and Time functions actually work is quite a big help when you're creating anything related to time based data.

When I first started learning FileMaker, I was pleased to see how easy it was to use the date and time functions. However, I didn't quite know how things worked underneath the hood. It wasn't until I tried creating my first calendar within FileMaker that I had to really get into the guts of what was going on.

Once I learned how the functions really worked, I was able to easily achieve the results desired. This video goes through the insides of how the date and time functions really work. This is what you really need to know in order to get the most out of FileMaker's date and time capabilities.

Comments

Thanks for the video. I'm building a time and miles worksheet. This will help a lot.

Ron Webb

Posted by: Ron Webb
Tue, 02/27/2018 - 9:49am

For your ref:
Here in UK date function is same ' Date ( month ; day ; year ) ' but does display as day/month/year , as UK standard
eg. Date (12;2;2019) = 2/12/2019

Posted by: Steve B Clews
Fri, 05/17/2019 - 6:13am

Thanks for the video! In the part where you talked about needing to account for a date rolling over to the next year, I thought it would've been useful to note that the Date() function supports automatic rollover, such as: Date ( 13; 1; 2018 ) = January 1, 2019

Posted by: Dillik
Wed, 10/02/2019 - 11:36am