Hello!
I’m trying to schedule facebook posts based on a date written in Google Sheets and formatted in YYYY-MM-DD HH:mm but when running the prompt it keeps on returning this error. I’ve tried to format the date but it doesn’t seem to solve it. Anyone can help?
I think you should be using parseDate
instead of formatDate
.
formatDate returns a string type variable.
parseDate returns a date type variable.
The date field probably wants a date type variable.
The date in Google Sheets is a string (text) variable.
Hope this helps! Let me know if there are any further questions or issues.
— @samliew
P.S.: Investing some effort into the Make Academy will save you lots of time and frustration using Make.
2 Likes
Thank you very much! It worked
1 Like