ISO FileMaker Magazine

When first starting with FileMaker, I remember learning all the default Date/Time/Timestamp functions. The documentation for FileMaker is great and the example calculations often lead you in the right direction.

One of the things I didn't know about was how dates, times and timestamps were treated internally. More importantly, how this impacted what I wanted to do with date/time calculations and integrating with external systems. Later down the road, I learned about all the other things I needed to know when considering time around the globe. Understanding UTC, how it impacts my solution, and running scripts on the server in a different time zone vs running them within the local client and how this might impact things based on times or dates.

This week's video and technique file will provide you with all kinds of understanding. The fundamentals and powerful custom functions which should provide you with a ton of date/time confidence for handlings most any date/time based task within FileMaker.

What's the easiest way to format a FileMaker date, time or timestamp value? Using a custom function? Maybe...

In this video, I'll show you a unique trick for getting a formatted date, time or timestamp value without using a Custom Function or any of FileMaker's Date or Time functions. Of course, I'll also provide you with one of the better custom functions for formatting date/time/timestamp values.

The custom function in this technique file handles pretty much all possible variations of date/time formatting and this includes ordinals such as 1st, 2nd and so on. If you're dealing with any type of output which requires a date, time or timestamp then make sure to give this one a watch.

It's a curious question and the answer may be good or bad depending on your perspective. "Why doesn't FileMaker have a time picker?". It has a calendar widget for working with date fields, why not time values?

The solution to the problem, as is often the case, can be managed by simply creating your own picker. In fact, if you don't like FileMaker's desktop based date picker you can create any variation you desire based on being able to create any style of layout you can imagine. While the same applies to a time picker, it may not be obvious how to implement if you've not worked with FileMaker for some extended amount of time.

In this video, I showcase a straight-forward time picker which works with both timestamp fields and time fields. It also includes some valuable utility scripts and concepts which can certainly be used in other areas of your FileMaker solutions. If you've ever come across the need for a time specific picker then adding this to your solution should save you a ton of time!

FileMaker Pro provides us with a wonderfully blank canvas in order to present data however we wish. It's called Layout Mode. When you combine that feature with the recently added Card Windows the power to solve presentation problems goes up quite significantly.

Such is the case when it comes to providing users with a date picker, or a calendar widget if you will. In previous videos, I've provided instruction on how to make a very simple calendar widget. When you combine that widget with a Card Window you simply gain full control about how a user makes selections for date values.

So, what's the best method of implementation? Well, like all things, there are many ways to approach the problem. In this video I discuss the use of global variables and the differences in context when working with Card Windows. I present some of the better ways to approach the solution and how to clean up after yourself when considering the use of global variables.

If you're in need of expanding your FileMaker knowledge and you happen to also need a simple, yet powerful date picker, then I'm sure you'll enjoy watching this video about a Universal Date Picker.

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.