Syntax Error for Date Format

(1) Share

Report

Posted on by BG-22101629-0

This is the code

{
    "host": {
        "connectionReferenceName": "shared_excelonlinebusiness",
        "operationId": "GetItems"
    },
    "parameters": {
        "source": "me",
        "drive": "b!NyPgHUxrPke7qKfFlSne640rbonEcL9Hlv0AeRKJJ0wjgsLYnfe8RotPC6Ea6ms-",
        "file": "01AKF4ANPHOHUV7NGYBZA25ULHJKGJQJJK",
        "table": "{8A5E506A-35F5-4648-B6D0-C28B0355BFFD}",
        "$filter": "Reminder Date eq ' 2024-10-22 ' ",
        "dateTimeFormat": "ISO 8601"
    }
}

while testing it it gives me an error like this given below

Syntax error at position 13 in 'Reminder Date eq ' 2024-10-22 ' '.
inner exception: Syntax error at position 13 in 'Reminder Date eq ' 2024-10-22 ' '.
clientRequestId: 6a111aaf-8da4-40bf-b364-94bae6235b07

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (0)

Suggested answer

trice602 15,404 Super User 2025 Season 2 on at

Like (1)

Report

Hi,

This looks good, just remove the extra spaces before/after the date.

------------------------------------------------

⭐ If this was helpful, please like and/or mark as a verified answer to help others find this too!

Always glad to help! 💯💯💯💯💯

Tom

Follow me on LinkedIn - Thomas Rice, PMP | LinkedIn

Was this reply helpful? Yes No
trice602 15,404 Super User 2025 Season 2 on at

Like (0)

Report

Hey there!

I am following up on this post syntax error for date format in this category building flows from 10/22/2024. I know the post is a little older, but it is a common question here so wanted to take a moment and follow-up. I see there have been 1 replies and 1 likes and asking if your question has been answered. If so, please help the community out by completing one or more of the following actions! Thanks in advance!

Easy as 1-2-3 ‼️💯⭐😎🆒🙏

1) Mark a reply as a verified answer - this is essential, and it helps others with the same general question find this thread. ✅

2) You can also mark one of more replies as a verified answer. Please take a moment and give the author credit for volunteering their time. ✌️

3) Like one or more replies. Kudos always greatly appreciated! 👍

Pro tip: if you found your own solution or workaround, feel free to add a reply to your own post and mark it as the solution too! The goal is to get this thread marked with a verified answer by anyone that finds one or more replies helpful!

Again, thanks in advance for reading and responding, always glad to help! Tom 💯💯💯💯💯

Was this reply helpful? Yes No
trice602 15,404 Super User 2025 Season 2 on at

Like (0)

Report

If I can help with anything else please let me know or tag me in a future post, I enjoy reading and answering questions. Always glad to help! Tom 💯💯💯💯💯

Was this reply helpful? Yes No