Skip to main content

Posts

Showing posts with the label Calculated field

Calculated field for Date column

In a SharePoint list or document library, we can create a calculated field. This field becomes handy when we have to display a formatted/calculated value based on the existing column. We often hear the requirements wherein we have to display a formatted value of the Date column. Ex., Display only Month value of a date column, display only Month and year part of the date column and so on. Let me show you how we can achieve this: For this example, create a list having a date field. When you create a list, by default, SharePoint adds two date fields "Modified" and "Created". So you can use any of these columns or you can create a custom Date field. After creating a list, now create a column of type "Calculated". Under the Formula text box, we need to enter the formula which will fetch us the desired value. In my example, I'm going to use a custom date field "StartDate". I want to display Month of the StartDate column in 3 characters like Jan, Fe...