Year and Month

[sathishkumar_go]

Hi All,

I have InvoiceDate.SpendDate,InvoiceReceiptDate,InvoicePaymentDate in Single table.

i want to take Year,Month,Day and week for each fields.

I taken Year,Month,Day and week from spenddate only. if i select the value year is 2008 it will not show all the values from InvoiceReceiptDate and InvoicePaymentDate. it will show belongs to spenddate. Because i am taken year by spenddate. but i want link with all date fields.

which 1 is gud, wheather i want to take year by each field by using resident or any other logic???

looking forward your replies???????????

-Sathish

[#2]

Hi Sathish,

I think if you want the selection to filter through to all the other dates as well

you will have to change the table structure from:

InvoiceDate, SpendDate, InvoiceReceiptDate, etc

1/1/2010, 2/3/2010, 1/3/2010, ....

to something like

DateType, Date, Year, Month etc

InvoiceDate, 1/1/2010, 2010, Jan...

SpendDate, 2/3/2010, 2010, Mar...

You can do this by concatenating each date field into one table, or using crosstable load.

[#3]

hi

i think Month , and Year , And Day , for one enough why going throug each one /////

[#4]

Common Calendar would be the solution..