Date and Number formatting.

[2005 IR Help]

By: kannan - lkannan

Date and Number formatting.

2004-11-09 13:20

Hi

 

$F{approvalDate} + $F{total}

 

I need to concate the date and the total.

 

Format required

 

Apr - 09 $16,713,998.

 

Please advice how I should this.

 

 

 

 

By: Mykel Alvis - evilarchitect

RE: Date and Number formatting.

2004-11-11 09:34

The easy way is by setting up variables with the desired formats.

 

Make a variable X for $F{approvalDate} with a format of ""

make a variable Y for $F{total} with a format of "$0.00" (or whatever format you want for that)

 

Then make a variable Z that is

new String($V{X} + " " + $V{Y})

 

See if that gives you what you want. Obviously, the eval times for each of these variables needs to be in sync.