Date in ISO format for date field in data items

Feature requests
,
1

It seems peculiar that the excel import doesn’t support date in iso format which is almost universally used here in Sweden.

I received this error when importing a excel file:

ERRORS

Message

Value ‘2024-02-14’ cannot be recognized as a date value. Cell:A2. Supported formats: “dd-MM-yyyy”, “dd/MM/yyyy”, “dd.MM.yyyy”.

Any thoughts on this?

2

Hello rcoswemail,
Could it be the date is stored as a text? I just tested it when I use a custom format and it seems to work OK.

You can configure this as:

  1. Select the cell with the date (example 01-01-2024)
  2. Press CTRL+1 on your keyboard (or right click and select “Cell properties”)
  3. Select Custom in the list of Categories
  4. Enter yyyy-MM-dd in the Type field
  5. Click OK

The date will be displayed as 2024-01-01 and will still be importable for Triggre.

1 Like