Date Data display

Hi everyone.

I have date data like this, (mine is US time setting)

But after i Formatted in new column and drag into chart, it is wierd, my data just until Jun.24 but you see now it has Sep and Nov 🙂

originally it is text type. So I thought that i should change this, so I go to Transform, and change text to Date, and then i got this, (this file is not manual, it is date data by system, not manual so i dont know why some data is error but some is not).

and by the way, I also created an auto calendar, but I dont know why it can not use and map to other tables (but i did map relationship date- date)

it is my calendar, is mmddyyyy, i also set the data Reqdate above is mmddyyy but when i drag this into chart it cant display then i still have to use repdate in table above as date.

 Please kindly help.

Thank a lot in advance