Article Tags

Hide tags

Click or tap one of the article tags to filter down to a smaller selection.

Show all content

Videos about "dates"

6 videos found.
FileMaker Date Formats & Functions 12/27/2021 - 4:39pm

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.

Formatting Date, Time & Timestamp Values 07/08/2021 - 2:22pm

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.

Time Picker Widget 12/31/2018 - 2:12pm

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!

Universal Date Picker 09/13/2018 - 2:49pm

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.

FileMaker Overview: Date & Time Functions 02/27/2018 - 6:00am

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.

Working with Relative Date Ranges 09/01/2016 - 11:41pm

Working with dates within FileMaker isn’t as complex as working on launching a rocket to the moon. But, as with most all technical things, it’s always good to know what’s going on under the hood. Knowing how things work allows you to implement the desired solution in the most efficient manner.

When talking about relative dates we’re talking about “Today”, “Tomorrow” and “Last Year”, not 7/6/1996. You can always instruct FileMaker to lookup a date range based on the whole year of 1995, but isn’t it nicer to simply provide the user with a menu with options relative to the current date.

In this video we take a look at the method of using relative date ranges in order to specify the starting and ending dates of those ranges. We do this using a Custom Function and some of the available triggers.

If you have any type of date-based data and you’re looking for an easy way to present things to your users, then you’ll likely find what you’re looking for in this video.