Hi guys, I’m quite new here and I’m through the majority of make academy but I’ve ran into an issue I’m really struggling to fix. I’m trying to make an automation that takes a preferred date and time from google forms, puts the values into google sheets, then format those so that I can use them to update google calendar. The issue I’ve got is changing the preferred time into the right format. I’ve been using the formatDate( and parseDate( functions but honestly after consulting with chatGPT I’m quite lost. Any help would be greatly appreciated.
I believe you are trying to parse the concatenated date and time from different sources and then format the result as a ISO8601 date to store it somewhere else. Is that so?
The error you see is because your date mask for formatDate() is wrong.
However, if your goal is to get a ISO8601 date, you don’t need formatDate() at all. parseDate() returns the date in that format.
That being said, you also don’t concatenate strings with a space using & “ “ &.
Just add a space between the two values and you’re good. Hint: add some other character instead of a blank space, like a dash, to make it easier to recognize visually.
For example: YYYY/MM/DD-HH:mm:SS.
Remember to parse the date using your Time zone of choice as the third parameter, since Make seems to always use UTC even when the docs swear it respects what you set up in your profile.
