Eclipse Community Forums: BIRT » Formatting Date as String in script

Home » Archived » BIRT » Formatting Date as String in script

Formatting Date as String in script [message #654858]

Thu, 17 February 2011 08:12

Eclipse User

I have a report that takes to parameters--startDate and endDate.

I want to create a single element in my report that outputs them in a form similar to:

Closed from 1/1/2011 to 1/31/2011

I'm currently using the following code to do this:

"Closed from "+
(params["startDate"].value.getMonth()+1)+"/"+params["startDate"].value.getDate()+"/"+BirtDateTime.year(params["startDate"].value) +
" to "+
(params["endDate"].value.getMonth()+1)+"/"+params["endDate"].value.getDate()+"/"+BirtDateTime.year(params["endDate"].value)

And it works, but I'm thinking there has to be a more "graceful" way of doing this.

Can anyone point out a better way to do this?

Thanks
Rick Seiden

Re: Formatting Date as String in script [message #654942 is a reply to message #654858]

Thu, 17 February 2011 12:09

Eclipse User

You could use a text element with syntax like:

"Closed from "+ <VALUE-OF format="MMM/dd/yy"
>params["startDate"].value</VALUE-OF> + " to " + <VALUE-OF
format="MMM/dd/yy" >params["endDate"].value</VALUE-OF>

Set the text type to html.

Jason

On 2/17/2011 8:12 AM, Rick Seiden wrote:
> I have a report that takes to parameters--startDate and endDate.
>
> I want to create a single element in my report that outputs them in a
> form similar to:
>
> Closed from 1/1/2011 to 1/31/2011
>
> I'm currently using the following code to do this:
>
> "Closed from "+
> (params["startDate"].value.getMonth()+1)+"/"+params["startDate "].value.getDate()+"/"+BirtDateTime.year(params["startDate "].value)
> +
> " to "+
> (params["endDate"].value.getMonth()+1)+"/"+params["endDate "].value.getDate()+"/"+BirtDateTime.year(params["endDate"].value)
>
>
> And it works, but I'm thinking there has to be a more "graceful" way of
> doing this.
>
> Can anyone point out a better way to do this?
>
> Thanks
> Rick Seiden

Previous Topic:	BIRT Runtime Localizations Not Working
Next Topic:	Double-byte characters not displayed in MS Word export

Goto Forum:

-=] Back to Top [=-

Current Time: Wed Jul 23 15:57:32 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter