[ASK] Anomaly with concatenate function

[#1]

Hallo dear QV users..

i have one or two question to ask.

I have a master table, and a concatenated table for transaction table.

Master Table field :

[Entry ID]	ID	MsDate	Quantity	Type
MS-1	1	03/31/13 12:02 PM	192	MS1
MS-2	2	03/31/13 05:53 PM	792	MS1
MS-3	3	04/30/13 08:12 AM	0	MS1
MS-4	4	04/30/13 08:12 AM	84	MS1
MS-5	5	04/30/13 08:12 AM	336	MS1

Transaction Table Field :

[Entry ID]	TransType	Date	Month	Year	MonthYear
MS-1	MS Tes	04/30/13 12:02 PM	4	2014	Apr-2013
MS-2	MS Tes	04/30/13 12:02 PM	4	2014	Apr-2013
MS-3	MS	04/30/13 08:12 AM	4	2014	Apr-2013
MS-4	MS	04/30/13 08:12 AM	4	2014	Apr-2013
MS-5	MS	04/30/13 08:12 AM	4	2014	Apr-2013

Concanate script :

Concatenate(Transaction)

LOAD

[Entry ID],

'MS Tes' as Transtype,

MsDate as Date,

DATE#(month(MsDate)&  '-' & year(MsDate), 'MMM-YYYY') AS MonthYear,

MONTH(MsDate) as Month,

YEAR(MsDate) as Year

resident MPRODPLAN;

I've tried without concatenate function, and there's nothing wrong.

But when i use concatenate, missdate are appears.

My question is :

Why date for MS-1 and MS-2 in transaction table are different?

And how to fix this?

Many thx before