BP Foundation / Section 9 / Activity 5a *** PROBLEM ***

[JonasHedström]

In this document Section 9 Activity Sheet.pdf, activity 5a, the instruction is to enter
Now() + MakeTimeSpan (0, 0, 5, 0)
into Defer Until, Add To Queue Action stage.

But, in the video description, this is entered
Today() & " " & LocalTime() + MakeTimeSpan(0, 0, 5, 0)
into Defer Until, Add To Queue Action stage.

The one at the top, ends up with this error:
"The following error has occurred: Your expression does not appear to be valid: Syntax error. The token '0' is invalid. Please check the case of your operators (eg 'or' versus 'OR') and check that your functions use brackets after the function name eg Now(), eg Len("abc")."

The second one (video) gets this error:
"The following error has occurred: Your expression does not appear to be valid: Syntax error. The token '0' is invalid. Please check the case of your operators (eg 'or' versus 'OR') and check that your functions use brackets after the function name eg Now(), eg Len("abc")."

QUESTIONS ===
What shall I do?
Why is there two different instructions?

Thanks in advance.

------------------------------
Jonas Hedström
------------------------------

[JonasHedström]

------------------------------
Jonas Hedström
------------------------------

[lookman]

Hi Jonas.

Both the of expressions you listed are valid syntactically. I checked them both very quickly using a calc stage.

Option 1:

Option 2:

I just cut and pasted the formulas as you posted.

jack

------------------------------
Jack Look
Sr Product Consultant
Blue Prism
------------------------------

[JonasHedström]

Hi Jack,

Thanks for trying to help me.

Please see attached. Both expressions, bot errors.

Why do I get that problem, but not you?
What can I do?
Is there any small setting I have missed anywhere?

Looking forward to complete BP Foundation.

------------------------------
Jonas Hedström
------------------------------

[JonasHedström · Accepted solution]

I solved it!!!

Change from: Today() & " " & LocalTime() + MakeTimeSpan(0, 0, 5, 0)
Change to: Today() & " " & LocalTime() + MakeTimeSpan(0; 0; 5; 0)

------------------------------
Jonas Hedström
------------------------------

[MelanieGiuliani]

@JonasHedström - so glad that you were able to resolve this! Thanks for sharing your solution.  ​

------------------------------
Melanie Giuliani
Online Community Manager
Blue Prism
------------------------------

[lookman]

Great news Jonas!

jack

------------------------------
Jack Look
Sr Product Consultant
Blue Prism
------------------------------

[SaharSalehi]

Hi Jonas. thanks for your answer and also your question. I started to follow your question since I also have a similar issue however it turned out even the code that finally worked for you is not valid for me. 

Any idea?

thanks in advance. 

------------------------------
sahar Salehi
------------------------------