Association two fields, one calculated

[#1]

Hi, I'm trying to create an association between two tables.  Table A has state and date, the Table B has state and week ending date.  I created a calculated field for week ending date in Table A.  When I try to create graphs on date, it shows one of the data sets by time, and lumps the rest into a bar, as if the association isn't working.  Image below.

I created test tables joining on state and date, no calculated fields, and it worked correctly.  I also created test tables joining on dates, one week ending, the other calculated to week ending, and that worked fine.  Having trouble with both at the same time.

we_date	valueb	state
1/8/2017	100	AZ
1/15/2017	110	AZ
1/22/2017	90	AZ
1/8/2017	200	TX
1/15/2017	190	TX
1/22/2017	210	TX

date	valuea	state
1/2/2017	12	AZ
1/3/2017	12	AZ
1/4/2017	12	AZ
1/5/2017	12	AZ
1/6/2017	12	AZ
1/7/2017	12	AZ
1/8/2017	12	AZ
1/9/2017	12	AZ
1/10/2017	12	AZ
1/11/2017	12	AZ
1/12/2017	12	AZ
1/13/2017	12	AZ
1/14/2017	12	AZ
1/15/2017	12	AZ
1/16/2017	12	AZ
1/17/2017	12	AZ
1/18/2017	12	AZ
1/19/2017	12	AZ
1/20/2017	12	AZ
1/21/2017	12	AZ
1/22/2017	12	AZ
1/2/2017	24	TX
1/3/2017	24	TX
1/4/2017	24	TX
1/5/2017	24	TX
1/6/2017	24	TX
1/7/2017	24	TX
1/8/2017	24	TX
1/9/2017	24	TX
1/10/2017	24	TX
1/11/2017	24	TX
1/12/2017	24	TX
1/13/2017	24	TX
1/14/2017	24	TX
1/15/2017	24	TX
1/16/2017	24	TX
1/17/2017	24	TX
1/18/2017	24	TX
1/19/2017	24	TX
1/20/2017	24	TX
1/21/2017	24	TX
1/22/2017	24	TX

[ahaahaaha]

Hi,

Please note that the date in the chart of your picture is in a numerical format. Perhapsyou have is one of the two dates presented in the form of a number, the other in the form of a date. Then there will be no association between the tables.

[#3]

How do I check?  They both show as dates in the association window.

[dwforest]

Try something like:

Date(Trim(we_date)))