Join two tables with different date types

[anuradhaa]

HI,

I have a table and it has date as YYYY-MM-DD.I'm using calendar thing too.

but in every month i need to add additional records to that table. So i have only month and year.

generally in month data i'm adding summary records.

Can anyone tell me how to handle this problem.

Thank you

[avinashelite]

Hi Anuradha,

Since you have master calender, link the date field with the master calender date by renaming.

If ur facing issue please upload the app

[MK_QSL]

Not understood completely from your description.. Can you elaborate little more with an example or sample...

[ramasaisaksoft]

Hi Anuradha,

             Can u please elaborate.I didn't understand u r problem.

[anuradhaa]

Here i have data for sales

CUSTOMER	RDATE_TIME	Sales
A	1/2/2005	20,578
B	2/2/2005	20,373
C	3/2/2005	22,381
D	4/2/2005	21,042

So i get these data from data base. Then i have use a calender and have Year,Month, Day list boxes. To view data based on selection.

Here i have use drill down group year,month,day.

suddenly i get monthly data from one Customer. I need to add them to this report. Then i have put that data in excel and join it with my existing table. the problem i have is i don't have date for my summary data.

I can use date in that month, but then all moth data display under that date. Is there a way to solve this.

Thanks