No empty fields for dates

tabitha shared this question 5 years ago
Answered

Hello,


What formula do i need to put in my calculated field with date range columns please. I have done what i normally do for other text columns but cant seem to make this work with a date field. I have tried putting a date in see attached and still get the same error.

Replies (10)

photo
1

The problem is your case statement need the if and else data types to be the same

If you use a Freehand sql you can convert 'on the fly' for example


case when to_char(date_issued) is null then 'No Date' else to_char(date_issued) end

photo
1
c1FxIgBpm+7alwMAAA== Content-Type: multipart/related; boundary="_006_a3f1fa1c3dc14726be0917dafe322be5W2K12EX13hblocal_"; type="multipart/alternative" X-Authenticated-Sender: smtpauth@hbprojects.co.uk Return-Path: t.grooby@hbprojects.co.uk X-MS-Exchange-Organization-ExpirationStartTime: 10 Apr 2018 14:07:12.3636 (UTC) X-MS-Exchange-Organization-ExpirationStartTimeReason: Original Submit X-MS-Exchange-Organization-ExpirationInterval: 2:00:00:00.0000000 X-MS-Exchange-Organization-ExpirationIntervalReason: Original Submit X-MS-Exchange-Organization-Network-Message-Id: 5419187f-fa41-40f7-e43c-08d59eec5b46 X-EOPAttributedMessage: 0 X-EOPTenantAttributedMessage: 27c9504a-c467-4376-b261-89b15e8ebb17:0 X-MS-Exchange-Organization-MessageDirectionality: Incoming X-Forefront-Antispam-Report: CIP:217.154.106.151;IPV:NLI;CTRY:GB;EFV:NLI;SFV:NSPM;SFS:(8156002)(2970300002)(438002)(199004)(189003)(377424004)(63266004)(7636002)(7736002)(7596002)(790700001)(6116002)(3846002)(67866002)(336012)(486006)(6916009)(5890100001)(5250100002)(5310100001)(19273905006)(229853002)(99936001)(476003)(126002)(11346002)(45080400002)(446003)(26005)(55016002)(6306002)(54896002)(59450400001)(54556002)(108616005)(24736004)(236005)(7696005)(9686003)(86362001)(33896004)(575784001)(53546011)(356003)(733005)(47076002)(15003)(6246003)(106466001)(66926002)(606006)(84326002)(5660300001)(1096003)(98436002)(8676002)(74482002)(101616003)(246002)(2900100001)(106002)(33964004)(15974865002)(16586007)(14454004)(102836004)(76176011)(16866105001)(15398625002)(562774006)(16866085005);DIR:INB;SFP:;SCL:1;SRVR:SYXPR01MB0173;H:smtp16.protectedservice.net;FPR:;SPF:Pass;LANG:en;PTR:smtp16.protectedservice.net;A:1;MX:3; X-Microsoft-Exchange-Diagnostics: 1;SY3AUS01FT006;1:lGQntoTKESWNpFMvdWNoV2QOaKKkVabwavOEGBRuNDgpJ7ezpkdadKMrgV/nux4EQKSlEOnRtp1pdEqvAqMHx1Z+7ECzGpLpk+zwHo1U2mViK/Qegt0UrF2Er8tNfjht X-MS-Exchange-Organization-AuthSource: SY3AUS01FT006.eop-AUS01.prod.protection.outlook.com X-MS-Exchange-Organization-AuthAs: Anonymous X-MS-PublicTrafficType: Email X-MS-Office365-Filtering-Correlation-Id: 5419187f-fa41-40f7-e43c-08d59eec5b46 X-Microsoft-Antispam: UriScan:;BCL:0;PCL:0;RULEID:(7020095)(5600026)(4604075)(4605076)(4608076)(49563074)(1401123)(1414027)(71702078)(7193020);SRVR:SYXPR01MB0173; X-Microsoft-Exchange-Diagnostics: 1;SYXPR01MB0173;3:AX3pQxXOaaJqdigH0jv1adEyVTIGl7bA+qlO0G/QM8Lk9GEwwmvzHQNTuL4KNFVU9j0wBAgUbgHcehkY3SohH8lYvk5XwdItd2gWMQtCAXYAdXopvoGoj7xzzKdU4sHxIySlcpjhvVBgt4s13lssQDKDr4CMxFWKT+AQDX6347P1iU5fPiie1VfmAHxTN+AZjaE661hHMg+Of0mAvD6wGFinFqbV0+uvuAElK2nNPd9SbOq1IX9yXV+8i/UIEEunRWYVIUAH4+uQI5hUqYyHPUzx3/XTngpAsqtGAAHyQMz8sIegCZaNPPeprHuezmj2Po4XzKITG1/pnsESSdJQe6S0Szbm89eaBLpQLzKpmCk=;25:GYlKGzNuDL76M/AgxFXYpCIZIjJwQYlmAV7GV/lUFssYcxkkNuQ9eQefMQh9K9tOqrpAJyBFlLu6vuwb3SAmXzty95l/zQZRo6BuzC2LGrrKKe4ZEoIxZnRw6eNj1OA8l80hvBc3gEHWbnhSKFg2USSNUjQ/qPIc6rvfW6bwC5xY1ET39JfFuD4JwQUQMt+6nWqj2qyN8MRtWILrpmBL7e4cJACQsR6fZclABXKS5n18k+oUrCFV+KRedFQTqLf/HJx6TFw88LAM9/PK25Cu2Jr3uEB2ybCumflRuljJM5l9vLLKf1ZiC+fGvQce79tI8mI1MJy7xdpQyc+ldBAy1A== X-MS-TrafficTypeDiagnostic: SYXPR01MB0173:|SYXPR01MB0173: X-Microsoft-Exchange-Diagnostics: 1;SYXPR01MB0173;31:fKIq57p6MjcX+M3dfPxFJTBf8jEz+tOjrPa66pMSAA7vUw17eA1O4jkJfxeiuClZyV71jaWnfj1W4w4qgQjSa5eaPDLS+lIk8YxsOKkEjobQO1R41wgJy2YsTLGkAc3U7sKV8rGx+ilJwANlkf3NiaYEo+EkRmt+Rj1ZYPUSpzUMTnDrOmeGr0xtxI3JhUKZObtTyB5zkvOF1Bmfae9R8rXltUMdNh9UCBFdhTga9Tg=;20:wfKgFtH32PTMlQGUoi4l1ebgFX4cpGz2+STyoeMoU7kfp25fjY5zDt0cJPgVRbLHWN+PxJZaLaCv9QkAgSECBJbhGeJTuZ5jl79OfOu/mdMj4HD8OFt1wXbu0nnD4WSi+AcITq9HftlanX46uVsJufX8aZAJJcbTGCxi0bs/VPDehw76RdScnWV0nX8s0Y0jFCuMITGpJHPUV3VHYPgjfWq8mM3y8mJJYx9CIgvQna51GUummy67CduC604hx+ZS X-LD-Processed: 27c9504a-c467-4376-b261-89b15e8ebb17,ExtAddr X-Exchange-Antispam-Report-Test: UriScan:(28532068793085)(31418570063057)(15185016700835)(128460861657000)(21748063052155)(81160342030619)(5213294742642); X-Exchange-Antispam-Report-CFA-Test: BCL:0;PCL:0;RULEID:(102415395)(2401047)(8121501046)(1430347)(1431041)(1432103)(1551027)(9101536074)(10201501046)(3231221)(902075)(913088)(7045084)(944500087)(944510158)(944921075)(946801075)(946901075)(52103095)(52105095)(52106095)(52401095)(52601095)(52606095)(52606095)(52606095)(52606095)(52606095)(52505095)(52406095)(93006095)(93004095)(3002001)(1610001)(8301001075)(8301003183)(9300000083)(9301000104)(201708071742011);SRVR:SYXPR01MB0173;BCL:0;PCL:0;RULEID:;SRVR:SYXPR01MB0173; X-Microsoft-Exchange-Diagnostics: 1;SYXPR01MB0173;4:WW+eN1xTgEq/QA2lz7XaI4mDp2oSyJEC12lE8KhfEj7SrLmldzj+pBjUIpszuPa01dtcG2ZfkIonl9S8NXkEXQec4tc4wHTTCDyuWPMKp2v7nmueujfNbGS84pauO/E0S30cD8xABWFyzo/Q5UFe6ueuOAH4h+X5AVVb3dT5IEcYdHxchfP8ntZnHt4ZJUcOQc1/0e48GWyOyAWpa0kbWePhPqo/TCXVNPU0sm+wJLgwRSe+3VkbBnApQsNFYqlOlITxSgmOPGBCX0ZYVE5gwBY5Zp9wnOTY4yFifHahCZlEmc4s1TClslOK+c62wuP1hJD4lUOY3wZrj0HgjbzhrZHsSInVK0BnM8HjkexbK+5f5RJMbIc3D11xt3/8CVAPQpasZp7vQRUQFCPm3yijj9W15MVHvr4as3z8Sv3IWNYUfZQ5Nisuhsqj440N43t46Xa3a5jfPDeLm6lytFBqM4+wSrSYCzOc5F+6x2056Rc6m6wASrNuxRU6CPhkdNEaSTAWqljQNUNlYLF+mvn/Ow== X-MS-Exchange-Organization-SCL: 1 X-Microsoft-Exchange-Diagnostics: =?utf-8?B?MTtTWVhQUjAxTUIwMTczOzIzOkxqWExpR3UydW5mSmo0NG93cUY1NVVnTXZR?= =?utf-8?B?eW5lNkV6WUkxWHZOUkg1TlZ1MHNQQ3dJc2kwWFlzeGdaQXBBZE9vUW95dEs2?= =?utf-8?B?aFg0aXJxZ1k4QTFhV0hsRXM0QXI3TWNRcnhLUTZoSUVWVUZZajJSNzYxa1NW?= =?utf-8?B?V1ZiZ0NLbmZiSldGdG9OMnVxS09sL0poeHJCSHNzMmE1TUhpNGNZWS9XdUZU?= =?utf-8?B?SmNYV3R2UFNhNTJUZzRVUTA1ZXU4Y0xUU3EvS1M0KzlCZHNmRWdWb01jOTF4?= =?utf-8?B?dTUxbERUUTJGbE1XaUpKWTF1K3c1V0dPZGwzS1hLUGdlaGx2aHZRU3BLNDJw?= =?utf-8?B?U0RRVG50YVFoMkZMUkJnSkdsZXJPdHdvRWcxSkxoR09xWjFoY1hWdXgxeUQ2?= =?utf-8?B?OG4weDEwcWlNWGVFVDhGTmpscFZlVVptV1Jhb293QUQ4cXQ5OHI2R2RJSkUx?= =?utf-8?B?bTAxOFV1VUM3eDlib291dEovek9JbkRMUGg2NnhsaGRuYkQ1L1hNWW1mMmhn?= =?utf-8?B?S1Z1K2dQWk1id1kyQVh3MHNncEtwQ1ltNm9uZ1pmWkNxNTR3MGVQM2RBaUp5?= =?utf-8?B?aHlrQm8zYnNKVkQyMGpCR3R5OTl1bExXTWc2cU5kbitORG5uam9aR05TVGh3?= =?utf-8?B?L2xFUnFKazgxZzd1VUwvTzJWZEFtMWFjSEVoc3NYTS9NaEptRXhUczdLMW9X?= =?utf-8?B?UnlZeE0rNjRHSmVwdFBncHlsTGFvQms2ejVmMFBVbU4rSzBoVFYxWXQ4dFZG?= =?utf-8?B?WDE2NzBuNy96Nk9nS2xKZDFNSWNYT0JVU1B5V2cwLzBXbWk0N1hHdmtRTzZy?= =?utf-8?B?UFFQc3pGaDh2R2NrRlQ4cEp6QjRvQ0RWNmZ0aGdCY3lSQjN5RVAzVjhmMkd3?= =?utf-8?B?ZmhPWEV6ekhpbHVuSno0djc3MjNBYnRxeUJtRXZXNUUzT3drTms2VjFxRFF3?= =?utf-8?B?dEg4YldMejRFUHhZR2VFS1dEazFBQzZ6MVVkRUlYVTZ5WUJ5VFY0UjVFejY0?= =?utf-8?B?R0RlVkdRYnJnUUtjM1JVYXFJUzY5Q0hzOThCZ1pJWk4zazZIazZjQkVvbE1v?= =?utf-8?B?Y3ZQREkvY2xRdjN3SDlIeVVPWElKMUZvQ3p5RjJBdjFNTkxMNUc5VStDRE95?= =?utf-8?B?czFqM2k3TDVRVktud29VV1VNSUw2cWJMRHN1NC9MUUhBOUdEeVR5SnB2RU41?= =?utf-8?B?dUIxU1MzTmVDZ2VaUzVFYkFJWkh3WDRMdlNIdjUzRjZ2bGZTc2ZPeWNYcTVB?= =?utf-8?B?Snc2M0VtT1ppV2FtTTJOVVpiQ0tlRG1SQVVIdzczM1QyRUwzZlRzQkJIaytN?= =?utf-8?B?UmZxMjRwWnZiaWhDV3dvNTdoSE9tNTdqRFFNSUFiSW5MN2E4YWZEelUwcTBt?= =?utf-8?B?L3p1MUJXYUNvSktzUVdpZHdlRTVmcElhQkJRTWloOUJQVEl0ZDZ0M2czT1pG?= =?utf-8?B?aTBmb2RGd1lXLzQ5Nyt3VE9CVVBOeGRYVENnQm1CbElDaXZGYlNmZXBZaStq?= =?utf-8?B?OW1DUVVhd0dkUHFlOGJDc1c5L0lTM1dYRTJoUS8xZHlLMlZwWlBMMHZQZ1VS?= =?utf-8?B?SUphTENzaGkzNW5RYmErYU1zcVZQc214L2RyR0VUb0ZlUktZVTBpMzhOZXNm?= =?utf-8?B?clRzbzE4dU1ac0pHMEd5cGxTSWFJeE5sazg2c3p4QVhsSEltUkNsbngwZ3hm?= =?utf-8?B?V0hoUXB2anQ4UVNCVUxhb2Z3WDhEMHBDWFBxNDhPSmltdFZhZGdJT0ZudFlZ?= =?utf-8?B?ODgwWmFmbHpDTlBPRis1NFY0ZnJxZjR0VDJhRFVOR015VzNqSm5KZHQ3VmQx?= =?utf-8?B?emUyQzZZNFhBN3N0alZTTld4TUpjZ29OeGhuY1NFdXpOU2JhZ2JhQzg3Q3pQ?= =?utf-8?B?RVliQ0FQcWM0eE81MnZXa3EreEhFdWg4QWNoMmgyYmlLMVRtWmZHQzlDN0Y3?= =?utf-8?B?V3RyS09xNU9VRlFrN1lwNzFsclpYOEV4NlhpVHZjbnlJazNNK3BNZFRudjh1?= =?utf-8?B?bENMYndzYzQyNGRibWNKYU1Ub09YUXBwWk5ScEhKUDB2RE5zWEJUTHlNN0hG?= =?utf-8?B?WDJ0QVVoVGxIdVRqVTVsMjFETjVaVElwcWUzQVFLd1Q2eE9NNjhCMWJoWkRN?= =?utf-8?B?dmNZSnYzbkJZS0RCak92aS9NZDRZamoycVlpSDhFeTFpTHhaRzJGZXpoQ093?= =?utf-8?B?Q1RhOEZ3R1VBUFA4K0VNMDJPenNnPT0=?= X-Microsoft-Antispam-Message-Info: KkwdI3hVW4mK3EAt8t428YlFD9C26qEKEgGikj15MP81fg3qAEWGWiUBsCWn2NARHR3TntdOKFv2zjSUdIMdeTitPBFNxHs3e94A28MdAuk3mQbojRGwdLVLS5NbToKz6vSBL1DtmmPJFtPNZ8ovIBKi2cIUHL3dR/XgyxG1AcmmIl7lF/YzSP9iW70gSGm9vnmVLr0yPyCHteLuZZkF/SOxp0Wb0Zowv8CPoiyqIGwpCyfC9heIFnB6TcIm8EWzTc+7C3XlzGO9DRDqfmL2s6ND0GnSMgHO8rFK/YehQ5r1Mh38dzwOIudJaezY1bgiyZYtXyUPG2cqkMG3nCA9f9yO6ZiHjrA171fxoU7m279XRwVjGFkvNa5AhYrPq18wJXCbEBB1TgFDsuA6RyzWChpW2RwNK3yr/98/xIDcPlo= X-Microsoft-Exchange-Diagnostics: 1;SYXPR01MB0173;6:gE4CWflQxBpBG7tuFF/7SRKUQOTB1+3E3P0eEafT9EpgVjN+hxF9UML+Z2IdlsnciL8Mod6skO6g5Hpwy3mzZLROZ44AaBzFFTQWy9+onVNXkpqUpzg1jg80v1Wvz5viDCFrUqVIK+neUYrKLW7etVtMwIIjngBMn5zKhamz7gFOvLBfOI+fALgcYQomo8ER9ONcywqDB9xdZmEs/JBB+q61Kih99dOyS9gbhjqi6nxgHSiPHq/dA1o4Ghagn6ZzesbFTD5j7xtlepgFJLR/IrVKDdgGzlUyuYNloF89OpksjodTWc822RQnEIih3J+NRItt++zcyOcpSdNw9JDlcC5qwfAUt/ZPxXc9BG5fFw8JRMUnPGx/fBtmIL4rmkLnJDPgxwiu3x+5tUZxDyvwXUCibXK1T2cXq/G07nJzcuegD4IwcL6mdtpGE4RshtIwd8KW9xm59JjlZB3TyO7lNQ==;5:qhBpmPUNh4gfNTwrIsx3Uns4GWBwTZ1K86DQWi0dv9gh25QMqvz/7iOLmJyNWRwpBa7da8DCX6eUChbotP2X5WyIWG8OVJ8CIM9sf9bPha9O/O0NZv0a+4G5KdtYRrhJR17PHXaPVFZNVPDqszmrVZpklA0ULIiM5llpz9kRlAY=;24:vMkJYv8lKfqYEwOX0vLR7VacCYKIqiTjn9yM8cFaGhwwu57Y0f/gRz71m9X2zducB5JLQcW/+M6ppForZVdR6+yQOg7nl1mbicVn2zyGQ18= SpamDiagnosticOutput: 1:99 SpamDiagnosticMeta 10 Apr 2018 14:07:06 GMT"; modification-date="Tue, 10 Apr 2018 14:07:06 GMT" Content-ID: Content-Transfer-Encoding: base64 X-Microsoft-Exchange-Diagnostics: 1;SYXPR01MB0175;27:/AKWG52iBNGD7Y1tEUkWBWAuM6oZT//knmBhWLzYtEcYVbGStt83QV1h/xobd/4//UkzJrGxy/kd6+ObzYH8tCq1N0j4YNx8qoSbRk7xqSXimPtLY0dUpOyxqUgkFqBW X-Microsoft-Antispam-Message-Info: mOBL3echYAY6lhGzPVJ0rdHf7oUHl+364vAzxaqdI+f7V39VPuW4Ju3EQ0Mi5zJOxJ9X+Mg6SZjKOdoLh7sEncv54/zDMr3fCkjjE7OCZkoK7vKTTb9Bh8udQKcZutydLIcXGdIl9wU3i5zfrVo3We5OXuiJF4HeB1jVbDyJPe9r44gg428A2fYIkNB4LME8jxWbHXzXVQRe2tHmIE40sF9dR44U/Rf7/Ygr8+k1mHnVgi0mP/aIiDi0eYXq9ZILEfHwCw+K+PuDw4EI+VGpmHgabLJ/2A3ztqFSYULIWFAv3Qcwe7uwAf2V6sNWRxrDu9vT7JAnLtGmqEEh86C4tJyOyWoLfOpNb6pC8azpGsgRxX4BRWTiaRWEruiOwRysRlDL1INP0GwBff8sBpRIOJ9wMMdm1dc07eWnbXNKlAk= /9j/4AAQSkZJRgABAQEAYABgAAD/2wBDAAoHBwkHBgoJCAkLCwoMDxkQDw4ODx4WFxIZJCAmJSMg IyIoLTkwKCo2KyIjMkQyNjs9QEBAJjBGS0U+Sjk/QD3/2wBDAQsLCw8NDx0QEB09KSMpPT09PT09 PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT3/wAARCABjAKUDASIA AhEBAxEB/8QAHwAAAQUBAQEBAQEAAAAAAAAAAAECAwQFBgcICQoL/8QAtRAAAgEDAwIEAwUFBAQA AAF9AQIDAAQRBRIhMUEGE1FhByJxFDKBkaEII0KxwRVS0fAkM2JyggkKFhcYGRolJicoKSo0NTY3 ODk6Q0RFRkdISUpTVFVWV1hZWmNkZWZnaGlqc3R1dnd4eXqDhIWGh4iJipKTlJWWl5iZmqKjpKWm p6ipqrKztLW2t7i5usLDxMXGx8jJytLT1NXW19jZ2uHi4+Tl5ufo6erx8vP09fb3+Pn6/8QAHwEA AwEBAQEBAQEBAQAAAAAAAAECAwQFBgcICQoL/8QAtREAAgECBAQDBAcFBAQAAQJ3AAECAxEEBSEx BhJBUQdhcRMiMoEIFEKRobHBCSMzUvAVYnLRChYkNOEl8RcYGRomJygpKjU2Nzg5OkNERUZHSElK U1RVVldYWVpjZGVmZ2hpanN0dXZ3eHl6goOEhYaHiImKkpOUlZaXmJmaoqOkpaanqKmqsrO0tba3 uLm6wsPExcbHyMnK0tPU1dbX2Nna4uPk5ebn6Onq8vP09fb3+Pn6/9oADAMBAAIRAxEAPwD2aiub /wCEv+38eH9Lu9TB6T48mD/vt+v4A0f2Z4i1TnUdWj0+E9YNOTL495X5/JRV8jXxaE83Y2dQ1Wx0 mHzdQvILaPsZXC5+nrWN/wAJXPqHGgaPeXwPS4mH2eD67m5P4Kat6f4T0jTZvPjtBNdd7m5YzSk/ 7zZI/CtjIyRkZHai8VtqGrOc/sfX9T51XWRZxHrb6Ym0/jK2W/ICj+x9f0znS9ZW8iHS31NNx/CV cN+YNdJXPTeM7Bpnt9LhutVuEO1ks4tyqfdzhR+dUpSlsvwE0luM/wCErn0/jX9GvLIDrcQj7RD9 dy/MPxWtW013S760N1a6hayQKMs6yjC/X0/Gsrb4q1X7z2eiwHsv+kz/AJ8IP1qu3w20K586TUUu L66mxvuZpSHz7bcAflTah109Nf6+8Ly6FqTxpYzuYtHgutXlHH+hx5jB95DhR+dN8rxTqv8ArJrP RYD/AAxD7RPj/eOEH4A0iaNr+kKF0nVo7uBBhbbUI+QPQSJg/mDS/wDCWTWHGv6PeWIHWeIfaIPr uTkfiBRZfYV/6/roK/8AML/wi99b/PYeJdUSY/eNyUnRj/ukDH4EUfafFen/AOustP1WMfxW0pgk /wC+Xyv/AI9Q/jWxuG8rRILjWJ8fdtE+Rf8AekOFX88+1N/s/wAR6xzqF/HpNuf+WFh88pHoZWHH /AR+NHvfbt8/6uGn2QXx5pcFylrqsd3pdy/3Y7uEjd9GXIP51la/8VtK0iV7e1guLu5XsVMSj8WG fyFdLpfhrS9HcyWlqpuG+9cSkySt9XbJqzqGk2GrQ+VqFnBcp6SoGx9D2oTpKWzt/X9bg1O254hr PxM8Q6vuSO5FjCf4LYbT+LdfyxWFYa/q2lzNLY6jdQux3NiQkMfUg8H8a9U1f4UaBdlm068ewk/u 7xIn5E5/WuE8QfD3VtAtJb1ntrqyixvmhf7uTjlTz3HTNehSqUWuVaHJOFRO7NvSPjFqdttTVbSG 8Tu8f7t/8D+ldxpHxL8O6ttQ3Zs5j/BdDZ/49939a8Dq5caRf2umwahPaulncHEUpxhzz0/I0Twt KXkEa815n01HIksavG6ujDIZTkH8adXzTouq6vp93FHo13cwyyuESON+HYnAG08Hn1rvIPijrug3 hsvEmmJJKgBbaRHIAeh4yp/SuSeDkn7rudEcRF76HrVFcjpvxO8OahCXe6ktXGMxzRHI/EZBorB0 prozXnj3L/gT/kR9H/69lpni8kLouCRnVrfofc07wJ/yI+j/APXstN8Yfd0T/sLW/wDM1X/L1+rJ +wdFXPWGB4/1f1Nlbf8AoUtdDXO2X/JQdVH/AE4W3/oUlRDZ+n6lPodFXO+AuPBtj9Zf/RjV0Vc7 4C/5E2x+sv8A6MahfA/VfqD+Jf12F8ZkjS7LBI/4mNr0/wCuq10Nc940/wCQXZf9hG1/9GrXQ0P4 F8wW7OehJ/4WLdDJx/ZcXGf+mr10Nc9D/wAlGuv+wXF/6Neuhon09Aic74HGPDpwP+Xu5/8ARz10 Vc94H/5F0/8AX3c/+jnroaKnxsI/CgorjdR+KOhaZqNzZXC3vnW8hjfbCCMjrg5qzoPxC0fxHqi2 Fit0JmRnHmRBRgdec03Smle2gueN7XPDNaA/t3UeP+XqX/0M122h8fBPXf8Ar5/rFXFa1/yHdQ/6 +pf/AEM12uh/8kT13/r5/rFXqVfhj6o4ofE/mee13/ib/kkfhj/rr/R64Cu/8Tf8kj8Mf9df6PTq /FH1/QVPaXocj4c/5GbSv+vyL/0MVvfFP/kfbv8A65Rf+gisHw5/yM2lf9fkX/oYre+Kf/I+3f8A 1yi/9BFD/jL0YL+G/U5uw6yfh/Wiiw6yfh/Wire4lse++BP+RH0f/r2Wm+MPu6J/2Frf+Zp3gT/k R9H/AOvZab4w+7on/YWt/wCZryf+Xr9Wd32Doq52z/5KHqf/AGD7f/0OSuirnrXI+Ieo+h06D/0O Sohs/QqXQ6Gud8Bf8ibY/WX/ANGNXRVzvgL/AJE2x+sv/oxqF8D9V+oP4l/XYXxp/wAguy/7CNr/ AOjVroa57xp/yC7L/sI2v/o1a6Gh/AvmC3Zz0P8AyUa6/wCwXF/6Neuhrnof+SjXX/YLi/8ARr10 NE+noETnvA//ACLp/wCvu5/9HPXQ15l4g+IT+DdcudG0/SbYwQkSAmRhkuN7HGPVjU3hT4n3fiLx Ha6ZLp0EKTbsushJGFJ6Y9q1lQnK9S2m5CqRXu31PN/GH/I5az/19yfzra+E/wDyPUP/AF7yfyFY vjD/AJHLWf8Ar7k/nW18J/8Akeof+veT+Qr0J/wX6HJH+L8zmdZ/5Duo/wDX1L/6Ga7XRP8Akieu /wDXz/WKuK1r/kO6j/19S/8AoZrtdE/5Inrv/Xz/AFioq/DH1QQ+J/M89rv/ABN/ySPwx/11/o9c BXf+Jv8Akknhj/rr/R6dX4o+v6Cp7S9DkfDn/Iz6V/1+Rf8AoYre+Kf/ACPt3/1yi/8AQRWD4c/5 GbSv+vyL/wBDFb3xT/5H27/65Rf+gih/xl6MF/Dfqc3YdZPw/rRRYdZPw/rRVvcS2PffAn/Ij6P/ ANey03xh93RP+wvb/wAzW9DDFbQrFBGkUSDCoihVUewFEsEU+zzokk2MHXeoO1h0I9D7143P7/Me hy+7Ykrnbf8A5KLfc9dMh/8ARkldFUYgiE5nESCZlCGTaNxUcgZ645NJO1xtXJK53wCc+DLHHrL/ AOjWroqZFFHBGI4kWNB0VRgD8KL+60FtbmD40/5Bdl/2ErX/ANGrXQ1HNBFcKFmiSRVYMA6ggEHI PPcGpKG9Egtrc52E/wDFx7r1/suL/wBGvXRUzyoxKZdi+YV2l8c49M+lPok7glY8C+J7AeP9Q5H3 Yv8A0WtN+GTA+P8ATcEdJP8A0W1e6T6VYXMpluLG1lkbq7wqxP4kUQ6VYW0qywWNrFIvR0hVSPxA rr+tL2fJbpY5/Ye/zXPnrxiw/wCEz1nkf8fcn862vhOwPjqHBH/HvJ/IV7VJo+mzSNJLp9o7scsz QqST6k4p0Gl2NrKJbeytoZAMb44lU/mBRLFpw5LdAVBqXNc+bdaZf7d1Hkf8fUv/AKGa7bQyP+FJ a8cjH2n+sVestoumOxZtOs2ZjkkwKST+VSLp1mls1ulpbrA5y0QjUKx9xjHYUTxSkkrbWHGg027n y/uX1H513/iYj/hUfhg5GPN/o9et/wBh6V/0DLL/AL8J/hUz6bZSW6QSWdu0Mf3I2iUqv0GMCnPF qTTtsKOHaTV9z5w8OMP+En0rkf8AH5F3/wBsVvfFNgPH13kj/VRf+givbU0bTY3V006zV1OVZYFB B9elOn0uwupTLcWVtLIeryRKxP4kUPFrnUrAsO+XlufNlgy5k+Ydu/1or6QGi6Yv3dOsx9IF/wAK Kbxq7CWHfcoarquo2Or2dpDHaOl4zLGz7gUwMnPrWhqM13baa89uIGliQu4fO0gDJxjpWP4lEjeI dAELqkhkl2sy7gPlHbIq5qUGpjS7sve2xUQvkC2IJG0999cB1DLDU9SvtAGohLRGdPMSP5iNuDwT 69Kbpuo6vqujw39ulivmqWWJt/qRjdn29KNA/wCRHtv+vQ/yNUfDcOqS+DrMWN1bRExnZvhJI5Pf dj9KANrQdYGt6Wt15RifcUdCc4YdeaTX7+60vTJb21SFxCpZ0kzyPYiqng6W3bQ/Jt4XhaCVo5ld tx8zPJz3zmpvFv8AyKuo/wDXE0ARS6hq8ejjUEispFEQmMQLKduMkA+uPaq9/wCJbmPRrPVLOGFr e5KJskJDKzHHUcECnpHq174dhtbeG1hWW2VPOeUsQpXGdoXrj3qn4msE0vwjY2ULErDcQqGYdTnr +dAGhrGqapotib2WO0uIIyPMVNyMATjIJyKuaprcOmaZHdlGlaYqsMS/ekZugrF1Jrm91mLRdbkS OyuAHia3UqJyDnYxJOPwqXxQoXWPDq4AiF3jHbPGKANVF1l4Q7y2MUhGfKEbOB7Ftw/lUWl6zJfS 3dlPCtvqFrw6Z3IwP3WB64Na9cxB/wAlJudnT7Cu/wDMYoAsaXq2pX+p31o8dogsmCMw3HeSCRgd qTT9V1W/v7+02WSNZuqM3zkNkZ4HameHv+Rk8Rf9do//AEE1X0lbtvEXiH7HLBGfOTPmxludpx0I oA1LbUL5NXltNQS3WJbfz1li3Y64IOfSo9O1S+1xGubJIbey3FY5JlLvLg43BQQAPxqFluIfAssU +4Xa2b7wx+bODk1a8Kbf+EX07Z08kfn3oAjbUtQs9WSzuo7eSOWB5Y5owy8rjIKkn1Heqc+u6va+ HBq89vZhSiv5IL7sMRjn8a6UsodVLAMc4BPJrC8cf8inef8AAP8A0IUASS3+q209iZYrR4LmVY3M e7cmQTnn6VIup3N/qt3Z2Hkxx2e1ZZZVLEsRnAUEdPUmtOD/AI94/wDcH8qwrzQ7k6lNqWhagtvc S/LNGw3xyEcc+hoAnttWvU1G7sr6KEtCqOkkWQHVt3Y5wfl9aKz4PF/2GaW08QwC2u4sYaL5lkB7 iigC7qul6le6xZXcDWipZMzIrlsvkYOcDj9a0NShu7nTZILcQCWVCjGRjtXIwSMDn9Ks+fF/z1T/ AL6FHnxf89U/76FAGPYadqVj4fXTgbR3jTykfcwBXB5Ix16UzS9O1jStIgsIWsT5SlRKxc985249 /Wtvz4v+eqf99Cjz4v8Anqn/AH0KAKOhaOui2LQ+aZpZJDLLIRjcx68dhSa/Y3Wp6XLZWphUTqVd 5CflHsAOav8Anxf89U/76FKJoyQBIhJ7BhQBW0qG5ttPigu/JLxKEBiJIIAAzyODVDxJpV7rFvHb 2z28caSLKWkLZJU9MAdK0zeRDUBZ/N5piMvTjbnHX6mie8jt7i2hcOXuHKJgZGQpY59OAadmBQ1f SJNb0cQzmOG8Q+ZFJGSRG46EHrUd3o1zq+jx2+ozRpeQuHjuIAcBh0bB/UVpS30MF9BaSFhJcBjG cfKdvJGfXHP4H0os76K/tPtNvuaMlgCVwW2kg4/EUWYrlWOTWUhCSW9lJKBjzBMyqffbtJH0zSaT o7WNxc3l1MJ726IMjhcKoHRVHoKt299HdadFeQpI0cqB0Xb8xB6cVFb3MGs2rgRzCFsqSwKbsEgj g56g0WYXMrw4ryanr95EAY5bnZExPysUGDz6Zp+n6XqthqF/d5sna9dXK7nATAxjOOa0dPvLaQtb WkLRxwM0eAgVQVOCB+dFzq9vaTTRyiQCBFeVwmVRWzgk+nynPpRZhdFW2029l1qW91E2xie2+zrF FuPBbJyT61HpumajoUbWtoYLqyDExLK5R4weducEEflW4zKq5YgD1Jpnnxf89U/76FIZlRafqFxr 0Oo3rW8cUETxxwxEsfmxkliB6DtS+JNNvNY017G2aCOOXG95CcjBB4AHtWp58X/PVP8AvoUefF/z 1T/voUAR2S3CWqrdiISLx+6JII/EVl2Fjqmky3axC2uYJ53mTc5jZCxyQeCCK2PPi/56p/30KPPi /wCeqf8AfQoAwz4YTUbya81ry5ZpAqpHFnbEozwCeSTnk0VuiaM9JEP/AAIUUAQ/2bZf8+dv/wB+ l/wo/s2y/wCfO3/79L/hRRTuwsH9m2X/AD52/wD36X/Cj+zbL/nzt/8Av0v+FFFF2Fg/s2y/587f /v0v+FKlhaRuGS1gVlOQRGARRRRdhY5nxFqFzY+Kbb7NJs3WoB+UHgyqD1rR1uZ49f0BFOFe4k3D HX903+NFFbW0j6Mz7kWukzavFbuSYhCsoA4IbzkGcjnoSPxNO8NXMr+G55Wb50nudpwBjEj44oop P4A+0WPCcry+EtMdzljbJk49qi8HTPP4ejeQ5bzpucY/5aNRRSl9r1/zGuhl+HruVvE95CSuw3Fz n5FycMMc4zSavcSN4qu7It/o1xDbxypj7ylnBGevQmiitLe98iOh18kMcsflyRo6f3WGR+VQ/wBm 2X/Pnb/9+l/woornuzYP7Nsv+fO3/wC/S/4Uf2bZf8+dv/36X/Ciii7Cwf2bZf8APnb/APfpf8KP 7Nsv+fO3/wC/S/4UUUXYWFWwtEzttYBn0jFFFFF2B//Z --_006_a3f1fa1c3dc14726be0917dafe322be5W2K12EX13hblocal_ Content-Type: image/jpeg; name="image002.jpg" Content-Description: image002.jpg Content-Disposition: inline; filename="image002.jpg"; size=1197; creation-date="Tue, 10 Apr 2018 14:07:06 GMT"; modification-date="Tue, 10 Apr 2018 14:07:06 GMT" Content-ID: Content-Transfer-Encoding: base64 X-Microsoft-Exchange-Diagnostics: 1;SYXPR01MB0175;27:/AKWG52iBNGD7Y1tEUkWBWAuM6oZT//knmBhWLzYtEcYVbGStt83QV1h/xobd/4//UkzJrGxy/kd6+ObzYH8tCq1N0j4YNx8qoSbRk7xqSXimPtLY0dUpOyxqUgkFqBW X-Microsoft-Antispam-Message-Info: mOBL3echYAY6lhGzPVJ0rdHf7oUHl+364vAzxaqdI+f7V39VPuW4Ju3EQ0Mi5zJOxJ9X+Mg6SZjKOdoLh7sEncv54/zDMr3fCkjjE7OCZkoK7vKTTb9Bh8udQKcZutydLIcXGdIl9wU3i5zfrVo3We5OXuiJF4HeB1jVbDyJPe9r44gg428A2fYIkNB4LME8jxWbHXzXVQRe2tHmIE40sF9dR44U/Rf7/Ygr8+k1mHnVgi0mP/aIiDi0eYXq9ZILEfHwCw+K+PuDw4EI+VGpmHgabLJ/2A3ztqFSYULIWFAv3Qcwe7uwAf2V6sNWRxrDu9vT7JAnLtGmqEEh86C4tJyOyWoLfOpNb6pC8azpGsgRxX4BRWTiaRWEruiOwRysRlDL1INP0GwBff8sBpRIOJ9wMMdm1dc07eWnbXNKlAk= /9j/4AAQSkZJRgABAQEAYABgAAD/2wBDAAoHBwkHBgoJCAkLCwoMDxkQDw4ODx4WFxIZJCAmJSMg IyIoLTkwKCo2KyIjMkQyNjs9QEBAJjBGS0U+Sjk/QD3/2wBDAQsLCw8NDx0QEB09KSMpPT09PT09 PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT3/wAARCAAXAEgDASIA AhEBAxEB/8QAHwAAAQUBAQEBAQEAAAAAAAAAAAECAwQFBgcICQoL/8QAtRAAAgEDAwIEAwUFBAQA AAF9AQIDAAQRBRIhMUEGE1FhByJxFDKBkaEII0KxwRVS0fAkM2JyggkKFhcYGRolJicoKSo0NTY3 ODk6Q0RFRkdISUpTVFVWV1hZWmNkZWZnaGlqc3R1dnd4eXqDhIWGh4iJipKTlJWWl5iZmqKjpKWm p6ipqrKztLW2t7i5usLDxMXGx8jJytLT1NXW19jZ2uHi4+Tl5ufo6erx8vP09fb3+Pn6/8QAHwEA AwEBAQEBAQEBAQAAAAAAAAECAwQFBgcICQoL/8QAtREAAgECBAQDBAcFBAQAAQJ3AAECAxEEBSEx BhJBUQdhcRMiMoEIFEKRobHBCSMzUvAVYnLRChYkNOEl8RcYGRomJygpKjU2Nzg5OkNERUZHSElK U1RVVldYWVpjZGVmZ2hpanN0dXZ3eHl6goOEhYaHiImKkpOUlZaXmJmaoqOkpaanqKmqsrO0tba3 uLm6wsPExcbHyMnK0tPU1dbX2Nna4uPk5ebn6Onq8vP09fb3+Pn6/9oADAMBAAIRAxEAPwDVJYgs SxGeT71IbedbZbho3ELHaHPQmtjwwkv2lka2M1rONrnAKqR610GrS2WnaO8MiIYymxIc43ew/wAa 9WpiHGfIlc+eo4NVKTqSlY4ywgjuHlEzMNsZZcHAzkAZPpzV2LSEDESyO3IA42nqQePTjg1Fo+mr qj3a5ZWSItGAcDOeAfamXGj39uJGlAxGm9iJAfl6VUpXk481iIQagpOFx66O5Kj7QAx9VIB4BJB7 gA9faoZNOdLloFk3usRkwo645AH1GD+NH9l3plji2je0PnIN/wDB/ntWovh8TwStCssc6xRtGGkG CT1OaTqcu8hxoue0DOu9Me1gkkMpby22kBce1POk7AWe4IVRljsPPAPy88jnrVlvD07aWkkZzOsj CVWkG0AelUxot+1sJtny7N4TeN2312+lCqXXxhKk0/4b28ypPG1tcyRb8tGxXcPairJ0e9+wm8aM LDt3ZZgCR64oreLUttTmnGUXqrXKqSS28h8t3jYcHa2P5U13eVt0js7erHJoopruTd7FzS9Q/s6a RmiEsUqFJEJxkfWrSatZQSOsOnlbeaPZNGZSS3oQe1FFQ6UZO7NY15wXKuhNL4ihZS0NgEnWIwxu XyFT6U3/AISFXYpNaeZbvCsTpvwSV7g0UVHsIdi/rdV9fwRGur2ht3tZrAvbBy8SiTBTPv3qb/hJ N9osckUyyrHsDRSAA+hxiiim6EHuJYuqtn+BnahetqU8JVCpWNYwu7OSKKKKG/Z+7ElfvW5S3P/Z --_006_a3f1fa1c3dc14726be0917dafe322be5W2K12EX13hblocal_ Content-Type: image/png; name="image003.png" Content-Description: image003.png Content-Disposition: inline; filename="image003.png"; size=2856; creation-date="Tue, 10 Apr 2018 14:07:06 GMT"; modification-date="Tue, 10 Apr 2018 14:07:06 GMT" Content-ID: Content-Transfer-Encoding: base64 X-Microsoft-Exchange-Diagnostics: 1;SYXPR01MB0175;27:/AKWG52iBNGD7Y1tEUkWBWAuM6oZT//knmBhWLzYtEcYVbGStt83QV1h/xobd/4//UkzJrGxy/kd6+ObzYH8tCq1N0j4YNx8qoSbRk7xqSXimPtLY0dUpOyxqUgkFqBW X-Microsoft-Antispam-Message-Info: mOBL3echYAY6lhGzPVJ0rdHf7oUHl+364vAzxaqdI+f7V39VPuW4Ju3EQ0Mi5zJOxJ9X+Mg6SZjKOdoLh7sEncv54/zDMr3fCkjjE7OCZkoK7vKTTb9Bh8udQKcZutydLIcXGdIl9wU3i5zfrVo3We5OXuiJF4HeB1jVbDyJPe9r44gg428A2fYIkNB4LME8jxWbHXzXVQRe2tHmIE40sF9dR44U/Rf7/Ygr8+k1mHnVgi0mP/aIiDi0eYXq9ZILEfHwCw+K+PuDw4EI+VGpmHgabLJ/2A3ztqFSYULIWFAv3Qcwe7uwAf2V6sNWRxrDu9vT7JAnLtGmqEEh86C4tJyOyWoLfOpNb6pC8azpGsgRxX4BRWTiaRWEruiOwRysRlDL1INP0GwBff8sBpRIOJ9wMMdm1dc07eWnbXNKlAk= iVBORw0KGgoAAAANSUhEUgAAAFkAAAAVCAYAAAAtkUK4AAAAAXNSR0IArs4c6QAAAAlwSFlzAAAO xAAADsQBlSsOGwAAABl0RVh0U29mdHdhcmUATWljcm9zb2Z0IE9mZmljZX/tNXEAAAqoSURBVFhH 5VlrbFTHFT4z9+56FwxmTQwxAdYsjxQaVAhEyKRAkRuC2qZVWjVEkGSx5US0iVLa9PWnsRyEKkUE 0VAFlG4xCyK8QqpC1VZVCWoTcCFVeYWXTSzzCAYM2IAf+7h3pt+593qxjY29kEZVO3C193HmzDnf nDnnm7FZWVlJ/6+tQs0cSmlrO5nmXFIWkdZ3D4UQRNIgstLbyPY/Xzlg340OZebda/0f6Gkl5lNg 0FxKtbsA27j4VzJguLJp3E/hMv1PkUi8ja67MyCvWrUqt+NhRtOMRHFlMaa057Zp0yafZVnhpqam hqVLl7ZmYwPLev2DXr9UNBpNZKvjbuThI4+JgApRQYGZWLRoUdrVI31ke+4C4GDApBGDcujs9XZK pxSRkSXQxCuBJ8lESN9qZmhw3j/xKPBNnM49+eNiKt7ZkyPxeDxP2KrKMIzH8gfnHcXzAoB0Lhun rVRqoSDB+Umj7cFvWTb971Y2f1DeW4jM2aSVhg3LoafKAxlIotmKRgwJ0panp9DUwsH0/idXaPGO I9TUmgLQMrthnYjmkO4EshTiQecRk2ZpHepNo1RqthDySV5OALrYsu0nIftmNhZIWxdInxHmPkrZ Y7Ppe0+yksYaUkYwscDZHnabLkvTtyYOo1lh1/1vThxOcyND6b2Dn2YPcg+Gmjxwp2b35kzStk/7 JDWY0ihUtsIy1x9n7bgUmEd3PPwiTD6nhrEcgHEhdG9Phwiw45dvUlvapgE+gxoRwbVXkA2zzcu9 uNPvwldeXn4iFos9Bj1fI2XvjZaX7/ucIPrPD+M36G+nr9JX1x2g2WPy6Y+nGunoBZADAE4A3ilo zB4QZU5xRHpxnjlgTLzrI6X0G+Tq6mqWbYPC7WllGyhiOTU1NVZk1KhJqCI+VJbkovLyY/G18bDM UTMgO0Dadh0Fg9W3Ck3veG2KxcYgxPIxiLZ8Pj+K6xEU17ZNFSi2EWsa0tUX4VQenDuvpNyPenCm u7bq6gqz5kR4jhTGQ4qR0fqomZOzF3LJO84UwAqg6F1GBG850oAAFmQAeG7jkaMH+k1KWoo+vnST hg8J0MzRQygU9NGZ5naqPtNEbQlYzmDfayTXHD483JeTs08odb9fSstqt6YWFhZeENL40C9oMPLA xXis6nXh0z8SwhjJ4ylUZ51Mvrd17doXFixZcrU3I+Lr1s0VhrlJal2oJYy19LuQfS4eiz0qwmYl cnmJNFynecnj+fzGWNXyZ8tL13boRCEOSzVmNVb4ExxkBknIKkKh24WwG6GVF309GZFWNBFg7l8y E8Er6ArAnvTmBwhiRTsWPkyThuXShRtJWvPRWXrmSyPowfsGZrTs/uQqlaFInr3W5kZ6D63fkYy+ QmidgygBEdEmExXWB7YQwIVcp+4XUqwUDBLnPw8QwzC/nfDTITwug5u6C7fBS4AzWZDcgOgp5CVo a/0BmaI8FApNlkr/TkpZoACQbdsHodTCUI/gHU/imnhV1fVoaenmVfF4bsjWv5WGLGHZjvFRqBFg 4gn0dey5EyHj9MsAcwsALJ4obn4vQgtB7ZaVjL8NwpKxQ+nnXxlL33/3cG8xxNwxq4aM5P6DyU4F wz0XEr+AVYiyBrCXlfAmLRS9AtBHceTB3vkMsiOeaaIFqWW08Ot3pBRO5NtKHaKUXFjXUHcjUsRR KRjglNL65boz9THsTm2slu9poX+FPj5Mwk8rKiq2TSgq+gZWQAmD6dglsBK03oanHGHLUthW0q3A 3+a0GxRuqrU6MTDbu+f3ze0WvbG3jq4h0l+aWUQTC9wtxqxwPg0ZHKDmNk4b3cPIIeifUWMDiV59 rqw0xhrj66psgLTa3aqKIQBDjAuHncruOQyAVRxR+ZDzrPVx5PpnypeUnnfSh9bTmcTiWyMUN0fC kfl4jzxgtCmtbuJTPiZ43IRIZDLYzjwGwZlo0rtO19c/jQlxOHA8vur3ZA3Zgyif3hfQfSGxAgAv 33XcKYRXkYc3L5jirI585OehA/zU3OLtcbop+sxAhnNpcNCDHfqx/GrduHUc59TCa9CNfpfGPcyg 8PJmgBTp18Fgjjn9hRiPFIQU7cg9gPy6xU1OHVHCXyX6Ui74egTpZrSr2ZnonR0A83M0urRlw7r1 f8Lt9L5A7Ov7sUstboGDc2ebE5QA8wiCgXCaQVrqtXt3kO+Fu2qTgpl0wGXGgYTH7kLF2UbkXtL7 8SEBoOe41unnt27dumvBggXX8JAJCXRvReSeYh1cz5hA4aYVBdiHNCJMpa5iycBzz0kbDKR7Y1Zy x4zcF7yuC+6i5CXj+tV1X9e7ji4gw9IwqFSEfD5fpks6LUGpGvDsbkHv0Cyybk0nAOjVLyd09QVt yNeQiN8H0CFDGo+mWttWQH2Z6fcfsJOpBPJuwLZVEtu0KHh5ZvMD1jHzWkvL4Y7zkw1VVWc6JhM6 F8dj8Z3R8uhpNhX307EmvnuvqcKJl07Beqci2h2iLiCj4zJbyldxRnFLh2EK8N1f+LHfT3rFri+w +/VdUC647iEwhGWI7JUOCEKUgpodYGqG/LsDbHURskK+1nI95N4A9WiGYSVSGi8Ozcv7O5jJz1gH em5F/6iHw2Qt1e6N66r+itjjgvx1yIfctJQNNP3yol9CZueBcZ+DXnxlmps39SDvRaBDHpyCsyRb HfSYBebBzZxeMxxZjxU577TGjLkvkEMD/Duh/gura0effNww5OP8rCStBsCnAqnUyym/GIncOwcR PQ0gvqMlODL3x38AOw+rgPn0obr6+r9EwkWrcD7xQ9aBgUdDpIxDj8HF1QhbCtgeFIYe65Cj1puD APKulxGI7x17Xb0Z5zjlBb1vjnzn+ZOm3vrLimnW8PAwS4k8E3ntZKZnD4fW6OvDwm9IBBO2sPyH kR+HASwLVKUt6AtaILD/wrtBKG7tJqXByL2m1HUlbK/46VMOgEJcwaagnjHCUM5y5qPVutixV8AN 85Bh7oOzhtTyxYZE4tlCInBs/0tw4SmAOgae+kCp2uH2hynSvy4rK+OCRlzowF5+EhlVVIvIfwGQ jEMhZc8/hV0rMZwJtvIDxLLStn3pVhx4d0CoDRuSE42t2E8Iutaecmgczo1wptGCudSUhIHNCZQK b5JbUxYdvniT8rBTvNiSdHaEmfSYMzAVSlADBpoCe0aaTTeu91V1RUFBQbKmpskKhRA9brRqbHv5 LFhj0zCr2zvH8rpz5/bh21S+x6/NHBdb8+379+//g9cvc1DD23Fs0+c0NlpYDU06EAj4ZzQ1pYsr K3GaTq/hPHhFYSj0QCKdHox6cbm2ru489HUpp6wfsmuQQqrwOwp/8QhA9mw0uvg608dIKLS+CfZC b6ctNtYNN2w+TgLgR97a6zIdaG7nMwu072w+6Bwrc/wl+MzC224zwF/+zT8czFk+YUGeOTIrSN4M zKusvACfNvLRg5nl4Ts73b319I6ji63scrBfXFxs4WKOe1vD+QYzmw5206Ufn2HgW21P/bq/8/4Q 0EXWmxDwr+5NpclA9rDTzhFwK0eq0wCUt/trT3b6s1SnnMLybZ3l+ZvTh1FnxIk8nz7DzUh/EPhv kzEDf6ZE+x7nb3x8AspMsHtzakgPBdNJ0p3k3d0Q1KTwN77AR8QVymv/BuZ8w5GsIjeNAAAAAElF TkSuQmCC --_006_a3f1fa1c3dc14726be0917dafe322be5W2K12EX13hblocal_--
photo
1

Sadly your comment/response is unreadable :(

photo
photo
1

But the if is issued_date and the else is issued_date? They are the same? It’s the then that it seems to struggle with I think.

Tabitha Grooby

Business Systems Manager 

HB Projects Ltd.,

Merrydale House,

Roydsdale Way,

Bradford - W. Yorkshire,

BD4 6SE

T:(01274) 474 080  M: 07964 027795

Bradford | Livingston | Gatwick

Twitter ]     [ LinkedIn ]     [ Website ] 

Sent from my mobile device – please excuse any autocorrect errors

Confidentiality Notice:-

The information contained in this message is confidential and intended for the addressee only.

If you have received this message in error or there are problems with it, please notify the originator

immediately. The unauthorized use, disclosure copying or alteration of this message and its attachments

is strictly forbidden.

Registered in UK|Number 3685752

Registered Address: Merrydale House, Roydsdale Way, Bradford BD4 6SE

Please consider the environment before printing this e-mail

On 10 Apr 2018, at 16:36, Yellowfin Support <support@yellowfin.bi> wrote:

photo
1

The case statement is an 'if then' so from your 'Built' case you want to put the value No Date if the date_issued is null


to do that using case both the result if date_issued is not null and if it is null must be the same data type (e.g. DATE or CHAR etc) to make that happen as 'No Date' cannot convert to a date value you have to convert the date_issued (from I assumed DATE format) into a character string using the to_char function.

there should be no problem using the same data field for both the if field and the else field as all you are doing is making it 'No Date' when the is no date_issued value.

Are you still getting the same error using the freehand sql?

photo
1

Hi Tabitha,

I have tried the same as you and don't get that error:


/B8qt5esMUmD7AAAAAElFTkSuQmCCAA==

and the column 'boardingtime2' I'm using is definitely a datetime and not a string:


/A4oI4jIsSicVAAAAAElFTkSuQmCCAA==


I am using the latest build of 7.4 and the database is SQL Server.

Please tell me which build of 7.2 you are using (Administration->System Information->Build)

and also which database you are querying and I will investigate further.

regards,

David

photo
1

it is build: 20170202

PIM / Union square.

Is this error occurring because I am on 7.2? do we need to upgrade?

It validates but when I try and save it the error occurs

photo
1

Do I need to do something different because mine says timestamp not datetime like yours does

photo
1

Hi Tabitha,

no, that's not the cause of the issue. It is actually a bug, and Bernard is correct, the bug is evident in 7.1 and 7.2 but fixed for 7.35 and 7.4.

I tested for the bug in the latest build of 7.2 (4th of Dec, 2017) and unfortunately it is still there, so this means that you will have to upgrade to either 7.35 or 7.4 to resolve the issue. I mean, I could raise a defect for the bug to be fixed in 7.2 if you would like but it will definitely be faster for you to just upgrade to 7.35 or 7.4 rather than wait for the bug to be fixed and tested and released in 7.2 (could be several months)

Please let me know which way you would like to proceed.

regards,

David

photo
photo
1

I am on Oracle 11.2 and YF 7.1 and I get the error initially described using the original statement

Just had a bit of a play and on 7.35 with Oracle the original statement is valid!


I guess that somewhere between 7.1 and 7.35 the statement is explicitly converted by Yellowfin

photo
1

Hi Bernard,

you are correct, the issue was fixed for 7.35 and 7.4.

Also, the issue was not specific for Oracle.

regards,

David

photo
1

Hello, we have now had an upgrade to 7.4. Which is great news.

I have put this formula into my calculated field


It has worked:

/6kYAAAAABJRU5ErkJggg==


but I now cant seem to change the date format as it thinks it is text?

/Jyw+VSqVCXV2dvEZEREREBHh4eMhLd6fDBL1ERERERPcL0xuIiIiISO8x6CUiIiIivcegl4iIiIj0HoNeIiIiItJ7DHqJiIiISO8x6CUiIiIiPQf8Px6yFehEF5aBAAAAAElFTkSuQmCC


where as the standard column next to it gives me these options

/LOUbzfcAAAAABJRU5ErkJggg==


what have I missed please?

photo
1

Hi Tabitha,

yes I can see what's happening, because databases don't allow you to substitute different data types within a CASE statement, Yellowfin has converted the date to a string and then that's why you're seeing the format options for a string rather than a date.

I can think of 2 ways around this:


1) You could use the Format Type of "Freehand SQL" (instead of what you're currently using, "Simple") and convert the hard-coded string date in the formula as follows:

/5QqtaFf0dvjTt+VtM+cHCgBAfkhpAD5db8yX8sYwACgAUhoAAEARkdIAAACKaMGU9vOvf3L+I6UBAADkibY0AACAIiKlAQAAFBEpDQAAoIhIaQAAAEVESgMAACgiUhoAAEARkdIAAACKqCgpDQAAABEfP6UBAAAgX6Q0AACAIiKlAQAAFBEpDQAAoIhIaQAAAEVESgMAACgiP6X9fxrm1gZud8QFAAAAAElFTkSuQmCCAA==

Incidentally, the above syntax is for a SQL Server database, I'm not sure which type of DBMS you are using, you may have to use different syntax if it's not SQL Server.

2) You could create exactly the same calculated field (as you've already got) in the view rather than the report, and then apply a Text To Timestamp or Text To Date converter:

/A3QqGjPhF9eqAAAAAElFTkSuQmCCAA==

(such converters only exist at the view level, not in reports)

I hope this helps, please let me know how you get on with it.

regards.

David

photo
1

Hi Tabitha,

just wondering how you are getting on with your CASE statement and dates?

regards,

David

Leave a Comment
 
Attach a file