nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Date conversion

tdavies · 2013-06-23T16:16:02+00:00

Hi, My date fields in my report that are showing up like (eg.1371887407 ) what is the best way to convert big int to date time or just date? I tried adding a computed column using the expression df = new Packages.java.util.Date();df.setTime(row["field_1"]);df but it gives me…

tdavies

Hi, My date fields in my report that are showing up like (eg.1371887407 ) what is the best way to convert big int to date time or just date? I tried adding a computed column using the expression<pre>df = new Packages.java.util.Date();df.setTime(row["field_1"]);df</pre>but it gives me the wrong date. It gives me Jan 16, 1970 4:04pm.

Find more posts tagged with

Comments

kclark

Assuming that is POSIX Time you should be able to convert it like this.<pre class="_prettyXprint">var time = new Packages.java.util.Date();time = new Packages.java.util.Date( 1371887407*1000 );this.text = time;</pre>Place that in the onCreate() of a label and the output should be. <div><pre class="_prettyXprint">Sat Jun 22 02:50:07 CDT 2013</pre></div>

tdavies

Thanks for your reply. How can I set this up to convert all my date fields? I need to change the values in all the date fields not the labels. How can I set it up that as dates come they are converted?

kclark

I haven't tried it but I think you could create a computed column using an expression like this<pre class="_prettyXprint">var time = new Packages.java.util.Date();var posix = row["TIME"];time = new Packages.java.util.Date( posix*1000 );time;</pre>And then use your computed column in your report items.

tdavies

That worked except for fields that were null then it gave me 1969-12-31