format datetime cells

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, nan_str

string to be used for NA and NaN values

prefix, suffix

string to be used as prefix or suffix

See also

Other cells formatters: colformat_char(), colformat_date(), colformat_double(), colformat_image(), colformat_int(), colformat_lgl(), colformat_num(), set_formatter()

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 2022-11-05 17:47:27 2022-10-12
#> 2 2022-11-05 17:47:51 2022-09-18
#> 3 2022-11-05 17:48:15 2022-08-25