Eclipse Community Forums: BIRT » Date Formatting Issue

Home » Archived » BIRT » Date Formatting Issue

Mon, 27 February 2012 14:21

Eclipse User

I am attempting to apply a format to two date fields that are within a data string:
"Client: " + dataSetRow["CLIENT"] + " Case No: " + row["CASENO"] + "; Referral: " + dataSetRow["RFRSRCNM"] + " Initial Contact: " + dataSetRow["INITDATE"] + "; Agency Status: " + dataSetRow["AGCYSTS"] + "; Acceptance Date: " + dataSetRow["ACPTDATE"]
Is this possible? I have tried value-of and, unless I'm just not entering it correctly (very possible), it doesn't work. Any assistance is appreciated.

Re: Date Formatting Issue [message #808565 is a reply to message #808423]

Mon, 27 February 2012 17:47

Eclipse User

Take a look at this post.
http://birtworld.blogspot.com/2011/02/birt-formatting-numbers-and-dates.html

If you are using a data item look at the Formatter.format function. If
you are using a text element with type set to html you can use something
like:
<VALUE-OF format="MMM-dd-yy hh:mm" > dataSetRow["ACPTDATE"];</VALUE-OF>

Jason

On 2/27/2012 2:21 PM, Michael Harless wrote:
> I am attempting to apply a format to two date fields that are within a
> data string: "Client: " + dataSetRow["CLIENT"] + " Case No: " +
> row["CASENO"] + "; Referral: " + dataSetRow["RFRSRCNM"] + " Initial
> Contact: " + dataSetRow["INITDATE"] + "; Agency Status: " +
> dataSetRow["AGCYSTS"] + "; Acceptance Date: " + dataSetRow["ACPTDATE"]
> Is this possible? I have tried value-of and, unless I'm just not
> entering it correctly (very possible), it doesn't work. Any assistance
> is appreciated.

Re: Date Formatting Issue [message #809107 is a reply to message #808423]

Tue, 28 February 2012 08:41

Eclipse User

Thanks Jason. I've read and re-read that post and tried the methods... can't get anything to work. Thanks anyway.

Re: Date Formatting Issue [message #809582 is a reply to message #809107]

Tue, 28 February 2012 21:34

Eclipse User

Michael,

What version of BIRT are you using? Can you dump some of your data to a
txt file then create a report against it that shows the issue so I can
run and debug it?

Jason

On 2/28/2012 8:41 AM, Michael Harless wrote:
> Thanks Jason. I've read and re-read that post and tried the methods...
> can't get anything to work. Thanks anyway.

Previous Topic:	BIRT CHART : Multiple Dataset on one Y - Axis
Next Topic:	help with XML datasource

Goto Forum:

-=] Back to Top [=-

Current Time: Wed Jul 23 11:03:04 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter