source date key vs calender date key issue

[Anonymous]

hi folks,

whats wrong in the script

date key created by adding month and year from source as date key

iam trying to join source date key with calender date key

iam not getting the association

plz help me out

plz find sample qvw

[anderslinden]

Hi!
You have a few issues. First you need to have a daynumer. I tried using the invoicedate instead to get the link and it links. Your issue here is that invoice date is not always in the invoicemonth. You need to know how the user want to sort invoice dates into invoice month. The link works: date(InvoiceDate,'M/DD/YYYY') as DateKey

[Anonymous]

hi anders,

i have invoice year, invoice month field.

how can i achieve datekey by using makedate? to join with calender date

invoice month --3,4.........

invoice year 2002,2003,..............

help me out

[CELAMBARASAN]

Hi,

     You can use

     MakeDate([invoice year],[invoice month]) as Date

Celambarasan

[anderslinden]

hi
I can see that you have mixed ut the order between year and month. Change

date (makedate(InvoiceMonth, InvoiceYear) into

date (makedate(InvoiceYear,InvoiceMonth), 'M/DD/YYYY') as DateKey

/Anders