{"id":356,"date":"2007-12-30T21:46:28","date_gmt":"2007-12-31T04:46:28","guid":{"rendered":"http:\/\/members.crystalreportsbook.com\/crystal-reports-xi\/b-7-data-type-conversions\/"},"modified":"2007-12-30T21:46:28","modified_gmt":"2007-12-31T04:46:28","slug":"b-7-data-type-conversions","status":"publish","type":"post","link":"http:\/\/www.crystalreportsonlinetraining.com\/training\/b-7-data-type-conversions\/","title":{"rendered":"B. 7 Data Type Conversions"},"content":{"rendered":"<p><b>Table 6-5. Conversion Functions<\/b><\/p>\n<table border=\"1\">\n<tr>\n<th>Basic Syntax<\/th>\n<th>Crystal Syntax<\/th>\n<\/tr>\n<tr>\n<td>CBool(number), CBool(currency)<\/td>\n<td>CBool(number), CBool(currency)<\/td>\n<\/tr>\n<tr>\n<td>CCur(number), CCur(string)<\/td>\n<td>CCur(number), CCur(string)<\/td>\n<\/tr>\n<tr>\n<td>CDbl(currency), CDbl(string),<\/td>\n<td>CDbl(boolean)<\/td>\n<\/tr>\n<tr>\n<td>CDbl(currency), CDbl(string),<\/td>\n<td>CDbl(boolean)<\/td>\n<\/tr>\n<tr>\n<td>CStr()<\/td>\n<td>CStr()<\/td>\n<\/tr>\n<tr>\n<td>CDate(string), CDate(year, month, day), CDate(DateTime)<\/td>\n<td>CDate(string), CDate(year, month, day), CDate(DateTime)<\/td>\n<\/tr>\n<tr>\n<td>CTime(string), CTime(hour, min, sec), CDate(DateTime)<\/td>\n<td>CTime(string), CTime(hour, min, sec), CDate(DateTime)<\/td>\n<\/tr>\n<tr>\n<td>CDateTime(string),<\/td>\n<td>CDateTime(date),<\/td>\n<\/tr>\n<tr>\n<td>CDateTime(date, time),<\/td>\n<td>CDateTime(year, month, day)<\/td>\n<\/tr>\n<tr>\n<td>CDateTime(string),<\/td>\n<td>CDateTime(date),<\/td>\n<\/tr>\n<tr>\n<td>CDateTime(date, time),<\/td>\n<td>CDateTime(year, month, day)<\/td>\n<\/tr>\n<tr>\n<td>CDateTime(year, month, day, hour, &#xB;min, sec)<\/td>\n<td>CDateTime(year, month, day, hour, min, sec)<\/td>\n<\/tr>\n<tr>\n<td>ToNumber(string), ToNumber(Boolean)<\/td>\n<td>ToNumber(string),<\/td>\n<\/tr>\n<tr>\n<td>ToNumber(boolean)<\/td>\n<td>ToText()<\/td>\n<\/tr>\n<tr>\n<td>ToText()<\/td>\n<td>IsDate(string), IsTIme(), IsDateTime()<\/td>\n<\/tr>\n<tr>\n<td>IsDate(string), IsTIme(), IsDateTime()<\/td>\n<td>IsNumeric(string)<\/td>\n<\/tr>\n<tr>\n<td>IsNumeric(string)<\/td>\n<td>ToWords(number),<\/td>\n<\/tr>\n<tr>\n<td>ToWords(number, decimals)<\/td>\n<td>ToWords(number),<\/td>\n<\/tr>\n<tr>\n<td>ToWords(number, decimals)<\/td>\n<\/tr>\n<\/table>\n","protected":false},"excerpt":{"rendered":"<p>Table 6-5. Conversion Functions Basic Syntax Crystal Syntax CBool(number), CBool(currency) CBool(number), CBool(currency) CCur(number), CCur(string) CCur(number), CCur(string) CDbl(currency), CDbl(string), CDbl(boolean) CDbl(currency), CDbl(string), CDbl(boolean) CStr() CStr() CDate(string), CDate(year, month, day), CDate(DateTime) CDate(string), CDate(year, month, day), CDate(DateTime) CTime(string), CTime(hour, min, sec), CDate(DateTime) CTime(string), CTime(hour, min, sec), CDate(DateTime) CDateTime(string), CDateTime(date), CDateTime(date, time), CDateTime(year, month, day) CDateTime(string), CDateTime(date), CDateTime(date, time), [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[19,1],"tags":[],"class_list":["post-356","post","type-post","status-publish","format-standard","hentry","category-appendix-b-basic-syntax-reference","category-crystal-reports-xi","entry"],"_links":{"self":[{"href":"http:\/\/www.crystalreportsonlinetraining.com\/training\/wp-json\/wp\/v2\/posts\/356","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.crystalreportsonlinetraining.com\/training\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.crystalreportsonlinetraining.com\/training\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.crystalreportsonlinetraining.com\/training\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.crystalreportsonlinetraining.com\/training\/wp-json\/wp\/v2\/comments?post=356"}],"version-history":[{"count":0,"href":"http:\/\/www.crystalreportsonlinetraining.com\/training\/wp-json\/wp\/v2\/posts\/356\/revisions"}],"wp:attachment":[{"href":"http:\/\/www.crystalreportsonlinetraining.com\/training\/wp-json\/wp\/v2\/media?parent=356"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.crystalreportsonlinetraining.com\/training\/wp-json\/wp\/v2\/categories?post=356"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.crystalreportsonlinetraining.com\/training\/wp-json\/wp\/v2\/tags?post=356"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}