i make a view with calendar style. i can’t see documents before pressing F9 and refreshing view. after refreshing the view i can see all the documents on the view. i use this selection formula.SELECT Form=“GEMSEF”&hat_secim=“2”&etd>@Date(@Now)
when i cut "&etd>@Date(@Now)formula the view works fine. but when i append this formula it makes problem which i described above.
how can solve this problem.
Subject: problem with calendar type view?
in general, it’s not a good idea to use time functions in selection formula’s.
These are three alternatives :
you could have an agent that runs overnight and marks all needed documents with a field, for example:
@If(etd > @today ; FIELD mark:=@true ; FIELD mark:= @False)
You could use this field then in your selection formula
tou could use a folder instead of a view, search for the documents and place them in the folder, somethin like:
Set dc=db.Search({Form=“GEMSEF”&hat_secim=“2”&etd>@Date(@Now)}, nothing, 0)
Call dc.PutAllInFolder(“MyCalendar”)
you could have an agent that runs overnight that changes the selection formula of the view thats uses a date constant instead of the @Now function, for example:
SELECT Form=“GEMSEF”&hat_secim=“2”&etd>[06/11/2004]