What is your goal?Need to calculate the time difference between the scheduled date/time (DD.MM.YYYY HH:mm) in an Excel file and the time from a Tally form (HH:mm) for the Estimated Time of Arrival (ETA).
What is the problem & what have you tried?The formular does not work and I do not know why it does not consider all brackets.
Error messages or input/output bundlesSee image.
Screenshots (scenario flow, module settings, errors)Hey Joachim,
none of the operators in that formula are actual operators. Its all free text. Replace every + with {{+}}, division is {{/}} and not just / and so on.
Also neither floor() nor parseDate() functions are closed.
Then there are a bunch of hanging " all over the place, not sure what those are supposed to be doing.
If you want to split() by space its {{space}} not just an empty space between two " ".
To get the current timedate its {{now}}.
If you want to combine strings, you just type them in one after the other, no need to add {{+}}.
There is one ; which is just free text and not the function {{;}}.
So yeah, your formula is kinda wrong.
I think your formula should be something like this:
{{floor((parseDate(formatDate(now; "YYYY-MM-DD"); space + 1.data.fields[4].value; "YYYY-MM-DD HH:mm") / 60000) - parseDate(formatDate(now; "YYYY-MM-DD") + space + last(split(11.c; space)); "YYYY-MM-DD HH:mm") / 60000)}}
You may or may not need to add parseNumber() around each parseDate(), I didn’t test it.
