Skip to contents

Date Utilities

Source: R/utilities.R
fg_date_utilities.Rd

COnverts a generic relative string defining one or two endpoints to exact dates or datestrings

Usage

gendtstr(x, today = Sys.Date(), rtn = "dtstr")

narrowbydtstr(
  xin,
  dtstr = "",
  includetoday = TRUE,
  windowdays = 0,
  invert = FALSE,
  addindicator = FALSE
)

extenddtstr(
  instr,
  begchg = 0,
  endchg = 0,
  mindt = NULL,
  maxdt = NULL,
  rtn = "",
  rtnstyle = "string"
)

Arguments

x

String describing generalized date as of today

today

Default Sys.Date()

rtn

string describing what to do: (list,datelist,fromtoday,totoday)

xin

Input data.frame or data.table with a Date column

dtstr

Generalized Date string of the form <yyyy-mm-dd>::<yyyy-mm-dd> or e.g. -3m::

includetoday

(Default: TRUE) pass either today Sys.Date() or Sys.Date()-1 to gendtstr

windowdays

(Default: 0)Number of additional days to add at beginning of series

invert

(Default: FALSE) Return dates not in dtstr

addindicator

(Default: FALSE) Returns original dataset with logical variable inrange if date is in desired range.

instr

Input generalized date string, data.table or xts dataset

begchg

(Default: 0) Number of calendar days to extend beginning

endchg

(Default: 0) Number of calendar days to extend end

mindt

Minimum date to return

maxdt

Maximum date to return

rtnstyle

REturn datestring or list

Value

an exact start date startdt and an exact end date enddt, in the following forms: If rtn="list" returns c(startdt,enddt), if rtn="first" then startdt, if rtn="days then an integer number of days from startdt to today otherwise (by default) "startdt::enddt"

Same form as xin, i.e. a data.table or data.frame

character string or list with new dates

Examples

gendtstr("-3m::")
#> [1] "2026-05-27::2026-08-27"
gendtstr("-2y::-3m",today=as.Date("2025-03-15"))
#> [1] "2023-03-15::2024-12-15"
narrowbydtstr(eqtypx,"-2m::-1m")
#> Key: <date>
#>           date   EEM      IBM    QQQ      TLT
#>         <Date> <num>    <num>  <num>    <num>
#>  1: 2026-06-29 67.43 276.0200 724.08 86.77863
#>  2: 2026-06-30 68.41 279.2071 736.40 85.75654
#>  3: 2026-07-01 66.48 284.2112 725.17 85.17688
#>  4: 2026-07-02 65.70 287.4579 712.60 85.16692
#>  5: 2026-07-06 67.57 297.3867 722.82 85.10715
#>  6: 2026-07-07 65.72 303.9496 709.43 84.21078
#>  7: 2026-07-08 66.23 299.8987 711.44 84.02154
#>  8: 2026-07-09 66.78 293.1967 723.28 84.15101
#>  9: 2026-07-10 66.90 285.5119 725.51 84.13110
#> 10: 2026-07-13 64.50 288.1629 711.74 83.63310
#> 11: 2026-07-14 65.67 215.5239 719.69 83.74266
#> 12: 2026-07-15 65.57 209.6957 717.74 83.90202
#> 13: 2026-07-16 64.19 217.4898 705.94 83.87213
#> 14: 2026-07-17 63.29 211.1553 695.33 84.18089
#> 15: 2026-07-20 63.56 211.4829 696.06 83.55342
#> 16: 2026-07-21 65.34 209.0007 708.97 83.32435
#> 17: 2026-07-22 64.99 204.3044 705.35 83.10522
#> 18: 2026-07-23 64.60 205.1781 691.96 82.83630
#> 19: 2026-07-24 63.33 212.6645 684.23 82.91599
#> 20: 2026-07-27 63.62 214.7396 682.12 83.41398
#>           date   EEM      IBM    QQQ      TLT
#>         <Date> <num>    <num>  <num>    <num>
extenddtstr("-2m::-1m")
#> [1] "2026-06-27::2026-07-27"
extenddtstr("-2m::-1m",begchg=-10,endchg=5)
#> [1] "2026-06-17::2026-08-01"