Can't IF with 00 (Zero Zero)

How To
,
1

Hello,

I have this input:

[
    {
        "Datum": "07.03.",
        "Beginn": "23",
        "Ende": "00"
    }
]

I wanna check if “Ende” is “00”

I tried
IF([Ende])=00;…
image

IF([Ende])=“00”;…
image

But after saving it removes one Zero

2

Looks like a bug.

For complex technical issues or bugs like this, directly contacting support can often lead to a faster resolution. They have access to your specific account details, scenario and scenario logs, server-side logs, and internal tools and resources, which allows them to investigate more thoroughly than what you have access to. Additionally, sharing sensitive information about your situation might not be suitable for an open forum discussion.

You can open a new ticket, or if you are unable to login for some reason, you also can reach support using the contact form on the website.

If you manage to get your issue resolved with support, we’d still love to hear about it! Sharing your solution on the forum can help others facing similar problems.

A workaround would be to use a replace function to build the string you want:

Screenshot_2024-03-06_220345

2 Likes
3

Try use switch

switch(Ende;00;……)

4

This won’t work. The bug here is that two zeros is treated as a number and converted and saved as a single zero.