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

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics