Filtering view by Date on the fly

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?

Joe
jforget1Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Sjef BosmanGroupware ConsultantCommented:
You almost gave the answer yourself. The same @SetViewInfo, and use a column with @Text(@Year(completion_date)). Would that do it??
0
jforget1Author Commented:
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))
0
Sjef BosmanGroupware ConsultantCommented:
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))))
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
jforget1Author Commented:
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.
-1,-1
2008,2008
-1,2007
-1,-1
etc.

Formula in the button to filter
@SetViewInfo([SetViewFilter];"2008" ; "comp_date";0)
0
Sjef BosmanGroupware ConsultantCommented:
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.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Lotus IBM

From novice to tech pro — start learning today.