Hi @Mixable,
The cell value returned when reading a date cell (via record.getCellValue('dateField')
) will always be an ISO 8601 formatted date string (YYYY-MM-DD).
If you instead call record.getCellValueAsString()
, it will return a date string with formatting dependent on the underlying field configuration. There are 5 supported date formats: local, friendly, ISO, US, and European. <CellRenderer />
respects the field configuration as well, and will render this formatted string.
This field option can be configured via the main Airtable UI (by double-clicking on the field name), or via custom blocks using the field.updateOptionsAsync metadata API.
For more information about expected cell formats & field options, you can check out the FieldType
enum in the API docs here.
Hope this helps!
Hi @Mixable,
The cell value returned when reading a date cell (via record.getCellValue('dateField')
) will always be an ISO 8601 formatted date string (YYYY-MM-DD).
If you instead call record.getCellValueAsString()
, it will return a date string with formatting dependent on the underlying field configuration. There are 5 supported date formats: local, friendly, ISO, US, and European. <CellRenderer />
respects the field configuration as well, and will render this formatted string.
This field option can be configured via the main Airtable UI (by double-clicking on the field name), or via custom blocks using the field.updateOptionsAsync metadata API.
For more information about expected cell formats & field options, you can check out the FieldType
enum in the API docs here.
Hope this helps!
Thank you @Billy_Littlefield!