How to output strings for this equation

Help
, ,
1

(‘Site Status’ = “Under test with alarms” ) AND ( ‘Create Date’ >= “1/1/2018 12:00:00 AM” ) AND ( ‘Create Date’ < “11/24/2019 09:00:00 AM”)

Capture

2

Hi,

You cannot use single quote for string expression.
Can you replace single quote to double quote?

Regards,

3

thanks Yoichi,

i want convert this equation to string : (‘Site Status’ = “Under test with alarms” ) AND ( ‘Create Date’ >= “1/1/2018 12:00:00 AM” ) AND ( ‘Create Date’ < “11/24/2019 09:00:00 AM”)

4

Hi,

Got it.
The following might help you.

"('Site Status' =""Under test with alarms"") AND ('Create Date'>= ""1/1/2018 12:00:00 AM"") AND ('Create Date' < ""11/24/2019 09:00:00 AM"")"

Regards,

5

sorry it working only till :
(‘Site Status’ =“Under test with alarms”) AND (‘Create Date’>= “1/1/2018 12:00:00 AM”) AND (‘Create Date’

but not added last part : < “11/24/2019 09:00:00 AM”)

thanks Yoichi for your attention :slight_smile:

6

Hi,

Thank you for your reply.
In my environment, there is no error as the following image.

img20191203-1
img20191203-11018×338 33.6 KB

Can you check your single quote and double quote are not ’ and ” but ' and "?

Because this forum automatically convert some special characters to non-ascii.

Regards,

7

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.