I often create this additional calculated date column so that I can easily sort content in a chronological order.

The following formula converts a date into a String “YYYY-MM

General Rules Are:

If Null then “None Assigned”
Else format as such 2008-12
Here is the corrected applied formula:
=IF([Effective Date]=”",”n/a”,TEXT(YEAR([Effective Date]),”0000″)&”-”&TEXT(MONTH([Effective Date]),”00″)
Go to the main page