Format date cells

Format date cells in a flextable.

colformat_date(
  x,
  i = NULL,
  j = NULL,
  fmt_date = get_flextable_defaults()$fmt_date,
  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_date

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_datetime(), colformat_double(), colformat_image(), colformat_int(), colformat_lgl(), colformat_num(), set_formatter()

Examples

dat <- data.frame(
  z = Sys.Date() + 1:3,
  w = Sys.Date() - 1:3
)
ft <- flextable(dat)
ft <- colformat_date(x = ft)
ft <- autofit(ft)
ft
z
w
2025-07-01
2025-06-29
2025-07-02
2025-06-28
2025-07-03
2025-06-27