Skip to content

Dates are interpreted in "Tue Jul 30 2024 10:00:00 GMT+1000 (Australian Eastern Standard Time)" format rather than ISO8601 #12

@mraadgev

Description

@mraadgev

Noticed when loading a Spreadsheet into Crate-O

If a date cell in Excel (e.g datePublished) is formatted as "Date" then the library is interpreting this date as a date and formatting in the Day, Month, Date, Year format as in the title rather than interpreting it as either an ISO8601 date or pulling the text as it appears when opening the spreadsheet.

If the cell is formated as Text then the data is loaded as expected.

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions