Skip to Content
Former Member
Dec 01, 2011 at 01:46 PM

Deriving Financial Year and Month from Posting date, obtained by a lookup.


Hi all,

Could you pls. help me regarding the following:

I need to derive the Financial Year and the fisc period month, from the Posting date in the Activities DSO.

But, this posting date is obtained based on 2 fields from the datasource viz.,

Object ID and Object Type and having a lookup on another DSO viz., Dates DSO.

It means that this posting date information is not available in the datasource of activities directly.

Now, in order to derive the financial year and the fiscal period month,

could any one pls. intimate how this can be done in the query designer level.

Thanks & Regards,