Filtering view by Date on the fly

Posted on 2008-01-30
Medium Priority
Last Modified: 2013-12-18
Have a DB which tracks completed tasks and accomplishments, have a view which shows all of the items. I have been asked to add a button which will allow the user to filter the view to show only records with a completion date in 2008. I have used the @SetViewInfo([SetViewFilter] in other dbs to filter for certain values, but they were text based. Is there a similar method I can use to do the same but to have it show only entries for this year?

Question by:jforget1
  • 3
  • 2
LVL 46

Expert Comment

by:Sjef Bosman
ID: 20782735
You almost gave the answer yourself. The same @SetViewInfo, and use a column with @Text(@Year(completion_date)). Would that do it??

Author Comment

ID: 20878411
Sorry for the delay here, got pulled on other projects. I am trying to combine the value from 2 forms into the same column, when separated the values compute to the year, but in the same column I get one good and one Icorrect Data type. is there a way to get these in the same column?

@Text(@Year(comp_date)) : @Text(@Year(end_date))
LVL 46

Accepted Solution

Sjef Bosman earned 1500 total points
ID: 20880005
For the document with the error, one of the fields doesn't contain a date value. It might be a text-representation of a date, or worse. Try this one first:

@Text(@Year(@TextToTime(@Text(comp_date))) : @Year(@TextToTime(@Text(end_date))))

Author Comment

ID: 20884244
I am no longer getting the error but the filter is not working.

The values I am getting in the comp_date column are sampled below.

Formula in the button to filter
@SetViewInfo([SetViewFilter];"2008" ; "comp_date";0)
LVL 46

Expert Comment

by:Sjef Bosman
ID: 20906972
Enable "display on separate lines" for that column.

Apparently, there are many columns that do not have both dates filled in. However, I think it doesn't matter here, the column is never shown to a user.

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

For Desktop Techs: How to retain a user's Notes configuration data when swapping out the end user's computer. (Assuming that you are not upgrading to a completely different version of Notes client) All you need to do is: 1) install Notes o…
Lack of Storage capacity is a common problem that exists in every field of life. Here we are taking the case of Lotus Notes Emails, as we all know that we are totally depend on e-communication i.e. Emails. This article is fully dedicated to resolvin…
This video tutorial shows you the steps to go through to set up what I believe to be the best email app on the android platform to read Exchange mail.  Get the app on your phone: The first step is to make sure you have the Samsung Email app on your …
If you are looking for an automated solution for backup single or multiple Office 365 user mailboxes to Outlook data file, then you can use Kernel Office 365 Backup & Restore tool. Go through the video to check out the steps to backup single or mult…

624 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question