From the course: FileMaker Pro 12 Essential Training

Unlock the full course today

Join today to access over 22,400 courses taught by industry experts or purchase this course individually.

Using date and time functions

Using date and time functions - FileMaker Pro Tutorial

From the course: FileMaker Pro 12 Essential Training

Start my 1-month free trial

Using date and time functions

The next group of calculation functions will allow you to manipulate Date/Time and Timestamp data. This group of functions are among the easiest to learn because of the easy syntax that each of the functions have. They fall under one of two categories, one of the categories are the functions that are going to extract a bit of information from Date or Time and then there's those that actually construct date, time or timestamps from bits of information that you are going to provide inside your calculation as parameters in the functions. Well, let's take a look at these. First, we'll go under File, Manage and Database, and you see that we've got a DateCalc function that's currently a Number. We are going to go ahead and change that to Calculation and hit Change and confirm, and now we are presenting with our calculation dialog. So let's isolate these functions on the right, Date functions first, so you see that nearly every single one of these functions has just one parameter, and that's…

Contents