From the course: FileMaker Pro 15 Essential Training
Unlock the full course today
Join today to access over 22,400 courses taught by industry experts or purchase this course individually.
Use date and time functions - FileMaker Pro Tutorial
From the course: FileMaker Pro 15 Essential Training
Use date and time functions
- [Voiceover] The Date, Time, and Timestamp functions are among the easiest to learn because they have really simple syntax. Let's take a look at them, we'll go under File, Manage, Database, I've got this DateCalc field already created, let's change it from a number to a calculation, hit change, tell FileMaker that's okay, and then we see our dialogue. So if we filter by just the date ones, we'll see that really, they come in a couple different formats, really just one of them has more than one parameter. Actually two of them, your name, but for example the date function is where we can have three parameters here, we can put in three different fields, or a number or a combination of fields and numbers. And the output of this would be a properly formatted date. In that case we would wanna actually store the results as a date so we make sure that the calculation result drop-down says date. But the rest of them will either output text or numbers. So for example, if we do day, and we put…
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.