Format datetime cells in a flextable.

colformat_datetime(
  x,
  i = NULL,
  j = NULL,
  fmt_datetime = get_flextable_defaults()$fmt_datetime,
  na_str = get_flextable_defaults()$na_str,
  nan_str = get_flextable_defaults()$nan_str,
  prefix = "",
  suffix = ""
)

Arguments

x

a flextable object

i

rows selection

j

columns selection.

fmt_datetime

see strptime()

na_str

string to be used for NA and NaN values

nan_str

string to be used for NA and NaN values

prefix

string to be used as prefix or suffix

suffix

string to be used as prefix or suffix

Illustrations

See also

Examples

dat <- data.frame(z = Sys.time() + (1:3)*24,
  w = Sys.Date() - (1:3)*24)
ft <- flextable(dat)
ft <- colformat_datetime(x = ft)
ft <- autofit(ft)
ft
#> a flextable object.
#> col_keys: `z`, `w` 
#> header has 1 row(s) 
#> body has 3 row(s) 
#> original dataset sample: 
#>                     z          w
#> 1 2021-11-15 21:55:24 2021-10-22
#> 2 2021-11-15 21:55:48 2021-09-28
#> 3 2021-11-15 21:56:12 2021-09-04