How to filter overdue records with "today" expression?

For HanDBase related topics that are not specific to one platform.

How to filter overdue records with "today" expression?

Postby daviderojas » Mon Sep 21, 2009 6:10 am

Hi again, I have a "todo" db with a date field, now some todo records in for future, I need to create a filtered view only with overdue records, but it must be automatically updated every day, i think there is a " today " expression, so when I open the database the filtered view calculet and show records "less or equal than <today()>" or something like that.

Anybody can help me please?, thanks in advance
daviderojas
 
Posts: 18
Joined: Fri Sep 11, 2009 8:37 am

Re: How to filter overdue records with "today" expression?

Postby dhaupert » Mon Sep 21, 2009 2:59 pm

Hi David,

I use HanDBase for this purpose as well, and all you have to do is set the filter on the date field. Choose Coming Year and that will show all records due from today throughout the next year. If that's too much, you can just choose today, or coming week to limit it down. But indeed this is a sliding filter that will adjust for the current date each time you launch the database.

Hope this helps!
dhaupert
 
Posts: 4111
Joined: Tue May 26, 2009 11:51 am


Return to HanDBase General Discussion

Who is online

Users browsing this forum: Bing [Bot] and 2 guests