Received Invalid Date error even though date looks correct
Hi, I'm getting an error that my date input is invalid. However, it appears the date is valid - Invalid Date for 'Due at': '2/22/2016'
Best Answer
A
Amanda Wong
said
over 7 years ago
Hi Saul, some apps require date inputs to be in a certain format. To find out if you are doing it correctly, you could do a simple Google search for the app API, looking for the particular date field that you wish to update. A commonly accepted date format is the YYYY-MM-DD format which you could use our to_date formula to achieve.
For example, if you have a MM/DD/YYYY date format, you could change it by adding .to_date(format: "MM/DD/YYYY") to the back of your data, in formula mode. to_date changes date formats to YYYY-MM-DD while format: "MM/DD/YYYY" tells Workato how to read the format of your date input.
Answer
Amanda Wong
said
over 7 years ago
Hi Saul, some apps require date inputs to be in a certain format. To find out if you are doing it correctly, you could do a simple Google search for the app API, looking for the particular date field that you wish to update. A commonly accepted date format is the YYYY-MM-DD format which you could use our to_date formula to achieve.
For example, if you have a MM/DD/YYYY date format, you could change it by adding .to_date(format: "MM/DD/YYYY") to the back of your data, in formula mode. to_date changes date formats to YYYY-MM-DD while format: "MM/DD/YYYY" tells Workato how to read the format of your date input.
Saul Macht
Received Invalid Date error even though date looks correct
Hi, I'm getting an error that my date input is invalid. However, it appears the date is valid - Invalid Date for 'Due at': '2/22/2016'
Hi Saul, some apps require date inputs to be in a certain format. To find out if you are doing it correctly, you could do a simple Google search for the app API, looking for the particular date field that you wish to update. A commonly accepted date format is the YYYY-MM-DD format which you could use our to_date formula to achieve.
Learn more in this article here.
For example, if you have a MM/DD/YYYY date format, you could change it by adding .to_date(format: "MM/DD/YYYY") to the back of your data, in formula mode. to_date changes date formats to YYYY-MM-DD while format: "MM/DD/YYYY" tells Workato how to read the format of your date input.
Amanda Wong
Hi Saul, some apps require date inputs to be in a certain format. To find out if you are doing it correctly, you could do a simple Google search for the app API, looking for the particular date field that you wish to update. A commonly accepted date format is the YYYY-MM-DD format which you could use our to_date formula to achieve.
Learn more in this article here.
For example, if you have a MM/DD/YYYY date format, you could change it by adding .to_date(format: "MM/DD/YYYY") to the back of your data, in formula mode. to_date changes date formats to YYYY-MM-DD while format: "MM/DD/YYYY" tells Workato how to read the format of your date input.