Now that we’ve established how the dates work at least basically, let’s throw out a crazy cool thing that Filemaker Pro does with dates… you can add with them. If I want to know the date tomorrow, I just ask for today plus one.
Get(CurrentDate) + 1
really. it’s that simple.
What can we learn from that? If you want to know the date 30 days from now, it’s an easy thing to find. There are some more interesting questions you might need to figure out.
How many days are left till the deadline?
How many invoices have payment overdue?
How many days has it been since the order was placed?
Let’s handle that last one:
Get(CurrentDate) – Invoice::date
In the example, we take two fields and calculate the difference between them. You want to take the later (larger) date and subtract the earlier (smaller) from it. (e.g. endDate – startDate )
How many hours till… wait… that’s a different Thing. (take a look at Thing # nn)
Leave a Reply