SharePoint Date Shows as Number

0
votes

Regardless of what I do in SharePoint 2010, one of my calculated columns show date as a long integer. Please see screenshot. enter image description here

My formula is below and it doesn't seem to respect it. I changed the column from date time to date. Created a new task and you see the date populates as I would want it on one of the tasks; but it doesn't for my older list items. Please advise.

=IF([Move to MTR2 Date]<>"",TEXT([Move to MTR2 Date],"mm/dd/yy"),IF([Move to MTR2?]=TRUE,"Requested",""))
1
sharepointsharepoint-2010

1 Answers

1
votes

Then get the date as

MONTH(date)&"/"&DAY(date)&"/"&YEAR(date)