https://forums.adobe.com/community/coldfusion/coldfusion_reporting?view=discussions Most recent forum messages en Wed, 19 Feb 2014 22:07:19 GMT Jive Engage 7.0.0.1 (http://jivesoftware.com/products/) 2014-02-19T22:07:19Z en https://forums.adobe.com/message/6137567?tstart=0#6137567 <!-- [DocumentBodyStart:9d35361d-b585-40f4-b91d-b8c05a889ecb] --><div class="jive-rendered-content"><p>Use the string concatenation character (ampersand) instead of the plus sign.</p></div><!-- [DocumentBodyEnd:9d35361d-b585-40f4-b91d-b8c05a889ecb] --><img src='/beacon?t=1415918138055' /> Wed, 19 Feb 2014 22:07:19 GMT forums_noreply@adobe.com https://forums.adobe.com/message/6137567?tstart=0#6137567 2014-02-19T22:07:19Z 8 months 3 weeks ago 0 https://forums.adobe.com/message/6118189?tstart=0#6118189 <!-- [DocumentBodyStart:b5e5a254-792f-43d7-852b-45ed7409ced5] --><div class="jive-rendered-content"><p>I have two fields that I need to concatenate after I have performed a calcutation. I am taking a school year and subtracting 5 years. </p><p>School Year = 201314. I want the result to be 200809 so that I can select any courses that have a School Year greater than 200809.</p><p>I have tried many variations of:</p><p>LEFT(sysvar.cur_schyr,4) - 5 + RIGHT(sysvar.cur_schyr,2) - 5 as "B4SchYr" this adds 2009 + 08 and gives me 2017 when I want 200809 returned. How do I treat the numeric strings as characters?</p><p>Thanks.</p></div><!-- [DocumentBodyEnd:b5e5a254-792f-43d7-852b-45ed7409ced5] --> Thu, 13 Feb 2014 19:42:32 GMT forums_noreply@adobe.com https://forums.adobe.com/message/6118189?tstart=0#6118189 2014-02-13T19:42:32Z 8 months 1 month ago 1 0