chr(39) is producing double quotes

[#1]

Hi Guys,

I am using the following statement

set cDate = '2013-09-24 18:32:59'

let ndate = 'Time <=' & chr(34) & '$(cdate)' & chr(34);

and expecting

ndate to be Time <= '2013-09-24 18:32:59'

but it is producing a string like this

"Time <="2013-09-24 18:32:59""

Any Solutions?

Chr(39) is producing double quotes instead of single qoute.

Saurabh

[mvanlutterveld · Accepted solution]

Hi Ramya,

Try this:

set cDate = '2013-09-24 18:32:59';

let ndate = 'Time <=' & chr(39) & '$(cDate)' & chr(39);

Michiel

[#3]

It is little bit strange.

If you see my subject of this post, it talks about chr(39) giving double quotes which was actually happening.

So i was just testing chr(34) to see if that produces single quote which it did not do and i posted a wrong question but when i thought to try the chr(39) again after looking at your post then it is working.

I have no idea.

Is there any external factor that determines the behavior of chr(39)?