Can i create Calculation object?

Hi

Can i create Object in Universe which is difference between the one Date object which is already there in universe and the Date Value user provides in Report prompt. Actually i need to calculate the difference between these 2 date values on the fly.

Please suggest.

Thanks in advance

Regards
KRG


krgodbole (BOB member since 2003-02-24)

Yes, you could. For Oracle for example:

TableColumn.Transaction_Date - To_Date (@Prompt ('Enter Date (for example 12/31/2004)', 'A',, mono, free), 'mm/dd/yyyy')

Andreas :de: (BOB member since 2002-06-20)

A formula , something like

DaysBetween(@Select(ClassName/Object) - @Prompt('EnterDate','D',,,,) ) 

should give you what you are looking for.


mkumar (BOB member since 2002-08-26)

Thanks for reply.

Actaully i missed one thing to tell that if i am using pre-defined filter to prompt for Date, if i use same prompt name in object description will it work?

Let me know if you need more info.

thanks
KRG


krgodbole (BOB member since 2003-02-24)

Yeah, it will still work.
As long as you keep the prompt name same in multiple object definition, it will appear only once.


mkumar (BOB member since 2002-08-26)