Skip to content

feature request: recognizable format datetimes write_excel_csv #1202

@keesdeschepper

Description

@keesdeschepper

As described in #553 and #948 datetimes written by write_excel_csv now have the format 2018/01/01 00:00:00. The pity is that readr's read functions do not recognize this format. Can it be changed to a dashed format, because afaics Excel also accepts that?

str(readr::parse_guess("2018/01/01 00:00:00"))
#>  chr "2018/01/01 00:00:00"
str(readr::parse_guess("2018-01-01 00:00:00"))
#>  POSIXct[1:1], format: "2018-01-01"

<sup>Created on 2021-04-30 by the [reprex package](https://reprex.tidyverse.org) (v0.3.0)</sup>

Metadata

Metadata

Assignees

No one assigned

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions