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 - FileMaker Pro Tutorial
From the course: FileMaker Pro 12 Essential Training
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…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.