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 = ""
)
a flextable object
rows selection
columns selection.
see strptime()
string to be used for NA and NaN values
string to be used as prefix or suffix
Other cells formatters:
colformat_char()
,
colformat_date()
,
colformat_double()
,
colformat_image()
,
colformat_int()
,
colformat_lgl()
,
colformat_num()
,
set_formatter()
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-06-12 15:18:31 2022-05-19
#> 2 2022-06-12 15:18:55 2022-04-25
#> 3 2022-06-12 15:19:19 2022-04-01