Discussions
Categories
Choose a Product
THRUST SERVICES
CORE APPS
CE PRODUCTS
...
Quick Links
POPULAR
HELPFUL TIPS
Groups
My Links
FOR SIGNED IN MEMBERS:
Back to website
Home
Designing Analytics Reports
return date in expression builder
Migrateduser
<p>Hi,</p><p> </p><p>I'm tring to do the following in order to return a date in a computed column of a date based on milliseconds as an input set:</p><p> </p><p>this is the expression:</p><p> </p><p><strong>[font="'courier new', courier, monospace;"]<span style="font-size:14px;">new Date().setTime([/font]<span style="font-size:14px;">row["value"]</span><span style="font-size:14px;">)</span></span></strong></p><p> </p><p>#row["value"] is miliseconds, i.e. : 1162684800000</p><p> </p><p>I get an error:</p><p><strong>[font="'courier new', courier, monospace;"]<span style="font-size:14px;">Can not convert the value of 1.1626848E12 to java.sql.Date type.[/font]</span></strong></p><p> </p><p>any idea?</p><p> </p><p>thanks,</p><p>Nadav</p>
Find more posts tagged with
Comments
There are no comments yet