I have a view that lists schedule dates for appointments. I want the dates displaying only if the scheduled dates are today’s date or a future date. How do I accomplish this with a formula? @If(SchedDate>=@Today;"SchedDate;@Success)
Won’t work.
Thanks in advance
Helen
Subject: Formula help Please
You could try the following formula:
SELECT SchedDate >= @Today
However, time/date-based selection formulas can cause performance problems due to the fact that the view is always considered out of date (in need of updating).
I suggest looking at the following Technote for a description of 1 possible workaround to this issue:
Lotus Software Knowledge Base Document
Title: Refresh symbol remains displayed on Notes view even though view already refreshed
Doc #: 1084688
URL: http://www.ibm.com/support/docview.wss?rs=899&uid=swg21084688
Subject: Formula help Please
The obvious may be the " in front of SchedDate - dont need to wrap quotes around a field name in column formula & plus you’re missing the second one.
Do you want these document to even appear in the view? Determining the documents that do or do not appear in a view may be accoomplished with the Selection formula - ie: SELECT SchedDate>=@Today
Are you sure that SchedDate is a Date/Time for a valid comparison?
May need to add a line of:
datevalue := @If(@IsTime(SchedDate); SchedDate; @TexttoTime(SchedDate));
and then
@If( datevalue >= @Today; SchedDate; “”)
Just random ideas of things I would look at…