cancel
Showing results for 
Search instead for 
Did you mean: 

Deferring Items

Anonymous
Not applicable

Hi All,

Why is this Expression Today()&**&LocalTime()+MakeTimeSpan(0, 0, 5,0) invalid? and
the following error has occurred:
Your expression does not appear to be valid:

The & operation must have two operands

and how to solve it?

------------------------------
Sanaa Fallah
------------------------------
1 BEST ANSWER

Helpful Answers

Hi Sanaa,

The & operator works with Text Data. If you don't provide text then auto-casting will take place into Text type. Here in the expression, ** is the invalid part. You need to enclose it within double quotes. The correct expression is: Today() & "**" & LocalTime() + MakeTimeSpan(0,0,5,0). This will return you something like this: 

33097.png

Let me know if your query is resolved.

------------------------------
----------------------------------
Hope it helps you and if it resolves you query please mark it as the best answer so that others having the same problem can track the answer easily

Regards,
Devneet Mohanty
Intelligent Process Automation Consultant | Sr. Consultant - Automation Developer,
Wonderbotz India Pvt. Ltd.
Blue Prism Community MVP | Blue Prism 7x Certified Professional
Website: https://devneet.github.io/
Email: devneetmohanty07@gmail.com

----------------------------------
------------------------------
---------------------------------------------------------------------------------------------------------------------------------------
Hope this helps you out and if so, please mark the current thread as the 'Answer', so others can refer to the same for reference in future.
Regards,
Devneet Mohanty,
SS&C Blueprism Community MVP 2024,
Automation Architect,
Wonderbotz India Pvt. Ltd.

View answer in original post

1 REPLY 1

Hi Sanaa,

The & operator works with Text Data. If you don't provide text then auto-casting will take place into Text type. Here in the expression, ** is the invalid part. You need to enclose it within double quotes. The correct expression is: Today() & "**" & LocalTime() + MakeTimeSpan(0,0,5,0). This will return you something like this: 

33097.png

Let me know if your query is resolved.

------------------------------
----------------------------------
Hope it helps you and if it resolves you query please mark it as the best answer so that others having the same problem can track the answer easily

Regards,
Devneet Mohanty
Intelligent Process Automation Consultant | Sr. Consultant - Automation Developer,
Wonderbotz India Pvt. Ltd.
Blue Prism Community MVP | Blue Prism 7x Certified Professional
Website: https://devneet.github.io/
Email: devneetmohanty07@gmail.com

----------------------------------
------------------------------
---------------------------------------------------------------------------------------------------------------------------------------
Hope this helps you out and if so, please mark the current thread as the 'Answer', so others can refer to the same for reference in future.
Regards,
Devneet Mohanty,
SS&C Blueprism Community MVP 2024,
Automation Architect,
Wonderbotz India Pvt. Ltd.