View Selection Based on Created Date without Refresh Indicator

Author: Tripp W Black

Created: 08/26/1999 at 07:51 PM

 

Category:
Notes Developer Tips
Formulas, Views

@Created

This view selection formula uses @Created to select only those documents created in the current month. To avoid having the view refresh indicator display, it uses @TextToTime("Today") instead of @Today. Date calculations in views may impact the performance of an application.

SELECT ( ( @Year( @Created ) = @Year( @TextToTime( "Today" ) ) ) & ( @Month( @Created ) = @Month( @TextToTime( "Today" ) ) ) )

previous page