Joining of two date fields

[#1]

Hello,

I would like to join two date field as a dimention in one table the date format is like 'DDMMYYY' and another table 'YYYYMM'.

I need to show as Monthname(Date Field) in X axis.

How to join these two fields to use as a dimention.

Regards

Chriss

[nirav_bhimani]

Hi,

Try this.

Go to Script and change the format of  DDMMYYY date

eg.

Date(CloumnName,'YYYYMM') as CalDate

Regards,

Nirav Bhimani

[Gysbert_Wassenaar]

DDMMYYYY is a date, but YYYYMM isn't. You can't join those two fields as they are. You can create another field from the date that makes the join possible. Try: right(MyDate,4)&mid(MyDate,3,2) as MyMonth. Formatting the date as YYYYMM with date(MyDate,'YYYYMM') doesn't do the trick since it only changes the text representation, not the numeric value of the date, i.e. it stays a date.

[#4]

Hello Gysbert,

Thanks for your reply, as you said I tried its not working....

Regards

Chriss