Error: Format of date for scheduling Facebook post

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 :slight_smile:

1 Like