Problem with date: Missing value of required parameter ‘start’

[danielem]

Hi Everybody.
I really need some help as I am GOING CRAZY HERE.

I am working for the past 2 hours on the following scenario

GOOGLE FORMS-> GOOGLE SHEETS (on google)
MAKE GOOGLE SHEETS-> CREATE EVENT

The problem is the date. I keep getting an error * Missing value of required parameter ‘start’.

My google sheet is based on Italian/European format , it means that the date is created with this format: DD-MM-YYYYY

I understood that MAKE can’t deal with that and therefore it leaves the date field blank

Can you explain me - in simple terms - what module (tool?) or what command I have to digit to make it work?

Thank you

Daniele

[Princy]

Paste the screenshot of tools “set variable” module result and input of google calendar module…

[danielem]

@PierreL

formatDate({{your_date_field}};YYYY-MM-DDTHH:mm:ssZ)

Thank you Pierre
where you suggest to place that?
In a tool module or in the calendar?

[danielem]

@PierreL

YYYY-MM-DDTHH:mm:ssZ

BTW Is not working…any idea?
Thanks

[danielem]

shall i need the tool or I could work also without it? like this?

I managed to process the date BUT I need also the time and I keep getting the error. Unfortunately there is not start time field for the event time in the calendar module… and so I have to integrate it in the DATE variable
Thanks!

[Msquare_Automation]

Hi @danielem

I think in your google sheet the date is in format MM/DD/YYYY. Calendar in start date is date column. So please use parse function
{{parseDate(1.Data di Arrivo; “MM/DD/YYYY”)}}

MSquare Support
Visit us here
Youtube Channel

[danielem]

Hi All

solved this!!! after so many tests…

This is the command to put in Start Date
{{parseDate(1.3; “DD/MM/YYYYTHH:mm”)}}

As far as I get you must tell the module in what format he receives the DATA/TIME info…mine came with this format dd/mm/yyy

Thanks everybody

[Michaela]

Heya @danielem

I just wanna quickly jump in and say congrats on solving this puzzle with the help of the community!

Thanks a lot for remembering to share what you learned with us and for marking your final setup as a solution. Thanks to that, our community stays tidy and neat and easy to navigate for folks looking for similar info in the future

Keep up the great work!