hr,finance views start and end dates

[Anonymous]

hi folks,

i have hr,finance views .

hr view data from 1-1-2012 to 1-29-2012

finance data from 2-1-2002 to 1-1-2012

how can i create common calender for the 2 views or different  calender for 2 views ?

plz help me its urgent

[jagan]

Hi,

Let me know what are field in HR and Finance.

You can simply concatenate the two views and arrive Month, Year, Week etc from that table.

Temp:

LOAD

     *

FROM HR;

CONCATENATE

LOAD

     *

FROM Finance;

Data:

LOAD

     *,

     Year(DateField) AS Year,

     Month(DateField) AS Month,

     '

     '

     '

     '

RESIDENT Temp;

DROP TABLE Temp;

Hope this helps you.

Regards,

Jagan.

[Anonymous]

hi ,

hr i have joining data from 1-1-2001 to 12-25-2011

finance i have invoice monthyear from 2-2002 to 11-2012

in finance other date field january month sales

how can i integrate these date fields to create calender.

[jagan]

Hi,

Can you attach sample file.

Regards,

Jagan.

[CELAMBARASAN]

Hi,

     Change the date field name of both hr and finance views to the date field name in master calendar.

Celambarasan

[v_iyyappan]

Hi,

     Cau u give us sample data.

Iyyappan.

[Anonymous]

hi plz find the attachment

Thanks in Advance