I am trying to import some data from a spreadsheet into a column (through Pipedream) and I am having trouble importing the date/time section. What format does this field has to be in, in order to be able to import in into the date column in Monday?
Importing dates seems to be quite flexible - I’ve tried importing the following formats and all seem to be recognised correctly within a Monday.com date column:
DD/MM/YYYY
YYYY/MM/DD
MMM DD YYYY (e.g. Mar 11 2023)
DD-MMM-YY (e.g. 01-Feb-22)
This format did not come through correctly:
MM/DD/YYYY
Hope that helps, but do reach out if there’s anything else we at IOI/BPX can help with!