filter_between: Filter records between dates

In steveneschrich/pgreportr: NIH Program Grant Reporting Library

Filter records between dates

Description

This function filters a reporting table, based on the variable var, to keep records with dates between start and end.

Usage

filter_between(.x, var, start, end = format(Sys.time(), "%Y%m%d"))

filter_grants_submitted_between(.x, ...)

filter_grants_funded_between(.x, ...)

Arguments

.x	The table to filter (can be any data frame)
var	The variable to filter dates on (changes between types).
start	Start date (YYYY-MM-DD)
end	End date (YYYY-MM-DD) default: current date

Details

This function filters a reporting table (grants, publications, presentations) to only those between the specified start and end date. The dates must be input as YYYY-MM-DD format.

If you are not sure what fields to use when filtering dates, consider using the filter_grants_, filter_publications_, filter_presentations_ functions which provide that information directly.

Value

A table filtered on start/end dates for var.

Functions

• filter_grants_submitted_between(): Filter grants submitted between dates

• filter_grants_funded_between(): Filter grants funded between dates

Note

If you do not specify an end date then today's date is used.

The dates are inclusive (meaning they include the date specified).

See Also

filter

steveneschrich/pgreportr documentation built on Jan. 13, 2025, 7:09 p.m.