Cordeiro82
MIS
Hello All,
I am trying to create a calculated column using an existing column that contains dates.
The statement is as follows : IF([start date] > 6/30/2010, "FY11", "FY10")
However, sharepoint does not seem to be reading 6/30/2010 as a date and keeps giving me FY11 as the return value even if [start date] = 6/1/2010
How can I solve this problem?
Thanks.
I am trying to create a calculated column using an existing column that contains dates.
The statement is as follows : IF([start date] > 6/30/2010, "FY11", "FY10")
However, sharepoint does not seem to be reading 6/30/2010 as a date and keeps giving me FY11 as the return value even if [start date] = 6/1/2010
How can I solve this problem?
Thanks.