creation of master calendar and comparing interval dates -

[#1]

Hi all

i have Sales order, eng ind date, module ind date, dispatch date etc in fact table. Sales order is unique key

i have calendar. AP start date.,, year, end date.

now i need to say.. how many eng inducted in an particular AP based on eng ind date

similarly for all the fields... is there any way... no interval match pls...

pl reply sooner

[#2]

May I ask why you dont want intervalmatch?

I believe is the easiest way

[#3]

i have many dates... so creation of tat many interval match is fine...??? will tat affect performance ???

can i get solution if so??

[#4]

Here is a quick solution though it creates synthetic keys