Hi there -
I’m new to all of this. After spending hours trying to figure out the correct formatting, I am trying here before I give up.
The following code is successful:
{
“query”: {
“filter”: {
“location_ids”: [
“{{2.id}}”
],
“start”: {
“start_at”: “2025-06-23T05:00:00-07:00”,
“end_at”: “2025-06-23T15:00:00-07:00”
}
}
}
}
However, when I try to replace the date time values in start_at or end_at to set them to today at 00:00:00 -7:00 and 23:59:59 -7:00 respectively, I get an error, without fail, every time. I’ve tried at least 100 iterations, using Make AI, Gemini, ChatGPT – I can not for the life of me figure out how to properly format this field. What am I doing wrong? Why won’t {{formatDate(now; “YYYY-MM-DD 00:00:00-07:00”)}} or setSeconds(setMinutes(setHours(parseDate(formatDate(now; “YYYY-MM-DD”; “America/Los_Angeles”); “YYYY-MM-DD”; “America/Los_Angeles”); 23); 59); 59), or anything else work?
1 Like
Hi Matt_Ramoundos, You have most likely a format error, try this one {{formatDate(parseDate(setSecond(setMinute(setHour(now; 23); 59); 59); "YYYY-MM-DD hh:mm:ssZ"; "America/Los_Angeles"); "YYYY-MM-DD hh:mm:ssZ"; "America/Los_Angeles")}}
1 Like
Sincerely appreciate the reply @Jonathan_Escobar. I believe I tried with parseDate as well. Still not clicking.
Error: 400 Bad Request
- {“errors”:[{“code”:“INVALID_VALUE”,“detail”:“Invalid timestamp (RFC 3339 format expected).”,“field”:“query.filter.start.start_at”,“category”:“INVALID_REQUEST_ERROR”}]}
1 Like
Is asking you for a date with the RFC 3339 format.
This is the same but with the T added.
{{formatDate(parseDate(setSecond(setMinute(setHour(now; 23); 59); 59); "YYYY-MM-DDThh:mm:ssZ"; "America/Los_Angeles"); "YYYY-MM-DDThh:mm:ssZ"; "America/Los_Angeles")}}
1 Like
Hi @Matt_Ramoundos,
Please try using the following formula:
start date:
{{formatDate(parseDate(now; “YYYY-MM-DDThh:mm:ss”); “YYYY-MM-DDT00:00:00”)}}-07:00
end date:
{{formatDate(parseDate(now; “YYYY-MM-DDThh:mm:ss”); “YYYY-MM-DDT23:59:59”)}}-07:00
I’ve attached a screenshot for reference.
If this helps, kindly mark it as a solution 
1 Like
