Date issue

[risabhroy_03]

I am using the below 

floor(num(Date([Invoice_Date_GMT]))) as [Invoice_Date_GMT_Updated],
floor(num(Date([As_On_Date_GMT]))) as [As_On_Date_GMT_Updated],
floor(num(Date([Ship_Date_GMT]))) as [Ship_Date_GMT_Updated],
floor(num(Date([Arrive_Date_GMT]))) as [Arrive_Date_GMT_Updated];

and each date individually works perfectly fine but when I combine them 

[Invoice_Date_GMT_Updated]& ''& [As_On_Date_GMT_Updated] &''&[Ship_Date_GMT_Updated] & ''& [Arrive_Date_GMT_Updated] as [Combined Date];

and when i use [Combine Date] in a table the year part for some of them comes as below

Please help.

[edwin]

hi can you provide sample data?

[risabhroy_03]

This is the sample data 

=Date(Ship_Date_GMT_Updated,'DD-MM-YY hh:mm:ss TT')

And If I just use floor(num(Ship_Date_Updated)) it comes like this -