Dec 1899 in SharePoint Calculated Column
I have a Calculated Column in my SharePoint List which is calculating based on other Date Column... to just Return "Month, Year" Eg July, 2010....
But the Problem is when that other Column is Blank this Calculated Column shows Dec, 1899....
Is that I could avoid that, I want the calculated column to be Blank when the Date Column is Blank...
Here's the Formula I am using:
=CONCATENATE(CHOOSE(MONTH([Date Column]),"Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec")," ",YEAR([Date
Column])
July 12th, 2010 7:01pm