• Documentation
  • Workato Blog
  • Product Blog
  • Return to Workato
  • Login
  • Automation Institute
  • Documentation
  • Community Forums
New Topic
Discussions Recipe Building Recipe Error Troubleshooting
S

Saul Macht

started a topic over 5 years ago
Answered

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 5 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.


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.

Answer

Amanda Wong

said over 5 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.


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.

Login to post a comment

Still can't find your solution?

Send us a ticket, we will try our best to assist you with your problem

Documentation
Developer's Library
Tutorials
eBooks
Product Hour
Product Blog
Workato Blog
Product updates
Customer Stories
© Workato 2022   Privacy   Terms   +1 (844) 469-6752
  • Documentation
  • Workato Blog
  • Product Blog
  • Solutions
  • Forums
  • Tickets
  • Log in
  • Return to Workato
Topic views count