Help with Data for Date...

Hi all... Its me again with more issues. 
 
I am building a report that will create a "projection" of information. This is based upon a frequency (freq) and a frequency unit (fut). I take a date field and named it nd. 
 
IE 
var nd = dataset.getTimestamp("date"); 
 
Now the bottom forumla works, thank ****... but the problem is when I try to use a getFullYear function or a getMonth function. For some reason BIRT sees using the DateTimeSpan and converts Next0 into a String or something... Below is some of the output... 
 
var Next0 = new Date(); 
 
var wk = -7 * freq; 
if (fut == "DAYS" && freq < 30) 
{ 
Next0 = DateTimeSpan.addDate(nd,0,-1,0); 
} 
else if (fut == "DAYS" && freq > 29) 
{ 
Next0 = DateTimeSpan.addDate(nd,0,0,-freq); 
} 
else if (fut == "MONTHS") 
{ 
Next0 = DateTimeSpan.addDate(nd,0,-freq,0); 
} 
else if (fut == "YEARS") 
{ 
Next0 = DateTimeSpan.addDate(nd,-freq,0,0); 
} 
else if (fut == "WEEKS" && freq < 5) 
{ 
Next0 = DateTimeSpan.addDate(nd,0,-1,0); 
} 
else if (fut == "WEEKS" && freq > 4) 
{ 
Next0 = DateTimeSpan.addDate(nd,0,0,wk); 
} 
 
Output: 
 
 
Mon Aug 17 10:31:37 PDT 2009 DEBUG DateNext0: Sat Apr 04 00:00:00 PDT 2009 
Mon Aug 17 10:31:37 PDT 2009 DEBUG DateNext0: Sat Apr 04 00:00:00 PDT 2009 
 
 
 
Now the issue is when I use the functions getFullYear or getMonth, BIRT states that the values are Null. So I tried converting the above into Date() functions... IE 
Next0 = new Date(DateTimeSpan.addDate(nd,-freq,0,0)); 
etc. 
 
But when I try to view the date and the getfullyear it returns null and a NaN value in the getFullYear() function... 
 
Is there an easy way to convert the Next0 string to a date? 
 
I am currently on BIRT 2.1.2.. 
 
Thanks in Advance 
Ben

Find more posts tagged with

Comments

cjmaloof

It sounds like this DateTimeSpan thing you're using is returning some sort of object which is not a Javascript date? That wouldn't be BIRT's fault. Two notes: 
 
1) If you're just looking to parse a string date in Javascript, I'd recommend <a class='bbc_url' href='http://www.datejs.com'>Datejs - A JavaScript Date Library About…</a>. 
 
2) Check out the BirtDateTime functions, which will work directly on the dates in your dataset. 
 
I'm not entirely sure if this addresses your question though.

Krelek1000

I finally figured it out... I had to add another line that parsed the string to a Date...

Next0 = new Date(Date.parse(Next0));

Then I added the scriptlogger and was able to use the getFullYear method.

Thanks all!
Ben