Finding records using date, time, or timestamp criteria


show more Finding records using date, time, or timestamp criteria provides you with in-depth training on Business. Taught by Cris Ippolite as part of the FileMaker Pro 11 Essential Training show less
please wait ...

Finding records using date, time, or timestamp criteria

Another one of the benefits while searching in Find mode is that the ability to be able to search within date and time fields. If you look inside of our exercise files, you see that we have got a couple of fields here, in the Invoice list, that are date fields and some that are time. So, for example, we have got Invoice date and ship time timestamp and then the ship time. In some of the more recent versions of FileMaker, there has been a lot of new improvements to date and time searching capabilities, and they are actually kind of cool. Each of the syntax that I will show here applies only to fields that are set up specifically as date, time or timestamp.

So the same types of techniques won't work in number fields, or text fields or anything like that. So, first let's look at date fields. You see that we have got several different dates in our database. If we hit Show All, we see all the different dates: 2011, 2009, and so on. They are all formatted as dates with month, day, and ye...

Finding records using date, time, or timestamp criteria
Video duration: 5m 18s 9h 11m Beginner

Viewers:

Finding records using date, time, or timestamp criteria provides you with in-depth training on Business. Taught by Cris Ippolite as part of the FileMaker Pro 11 Essential Training

Subject:
Business
Software:
FileMaker Pro
Author:
please wait ...