{"id":69,"date":"2010-05-06T13:34:42","date_gmt":"2010-05-06T17:34:42","guid":{"rendered":"http:\/\/erics-test-lab.com\/?p=69"},"modified":"2012-04-19T19:29:39","modified_gmt":"2012-04-19T14:29:39","slug":"coldfusion-output-value-formats","status":"publish","type":"post","link":"https:\/\/www.esearing.com\/v2010\/2010\/05\/coldfusion-output-value-formats\/","title":{"rendered":"Coldfusion output value formats"},"content":{"rendered":"

a library of things I use regularly but can never find when I need them. I will add to it over time.<\/p>\n

#datetime(fieldname, \"mm\/dd\/yyyy\")#
\n#DOLLARFORMAT(fieldname)#<\/code><\/p>\n

Excel formatting:
\ncolor alternating rows
\n<tr bgcolor=\"###iif(currentrow MOD 2,DE('ffffff'),DE('ffff99'))#\">
\nnumber as text in excel
\n<td style=\"mso-number-format:\/@\">#field#<\/td><\/code><\/p>\n","protected":false},"excerpt":{"rendered":"

a library of things I use regularly but can never find when I need them. I will add to it over time. #datetime(fieldname, “mm\/dd\/yyyy”)# #DOLLARFORMAT(fieldname)# Excel formatting: color alternating rows <tr bgcolor=”###iif(currentrow MOD 2,DE(‘ffffff’),DE(‘ffff99’))#”> number as text in excel <td … Continue reading →<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[5,16,24],"tags":[],"class_list":["post-69","post","type-post","status-publish","format-standard","hentry","category-code","category-coldfusion","category-snippets-quick-code-tips-for-single-elements-attributes-or-details"],"_links":{"self":[{"href":"https:\/\/www.esearing.com\/v2010\/wp-json\/wp\/v2\/posts\/69","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.esearing.com\/v2010\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.esearing.com\/v2010\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.esearing.com\/v2010\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.esearing.com\/v2010\/wp-json\/wp\/v2\/comments?post=69"}],"version-history":[{"count":1,"href":"https:\/\/www.esearing.com\/v2010\/wp-json\/wp\/v2\/posts\/69\/revisions"}],"predecessor-version":[{"id":525,"href":"https:\/\/www.esearing.com\/v2010\/wp-json\/wp\/v2\/posts\/69\/revisions\/525"}],"wp:attachment":[{"href":"https:\/\/www.esearing.com\/v2010\/wp-json\/wp\/v2\/media?parent=69"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.esearing.com\/v2010\/wp-json\/wp\/v2\/categories?post=69"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.esearing.com\/v2010\/wp-json\/wp\/v2\/tags?post=69"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}