Skip to Content
0
Former Member
Mar 02, 2009 at 01:40 PM

date calculation in report

28 Views

Hi,

in rpt i need to show the diff b/w 2 dates.

i.e., (END_DATE- START_DATE).

so i have created 2 formula variables on END_DATE- START_DATE.

i just wanna confirm whether i created it properly or not.

Procedure:

Under Formula Variable-->New Variable.

Type of Variable: Formula

Processing by : Replacement Path

Ref Char: END_DATE.

in replacement tab

Replace Variable with: InfoObject

Replace with: Key

Use Interval: To Value

Offset Start: 0 & Offset Lenght: 0

Currency/Unit:

Dim : Date

same procedure for START_DATE(Use Interval: From Value)

then fomula: END_DATE - START_DATE.

any thing to change ??

regards,

kv