Skip to main content

Posts

Showing posts from July, 2016

SharePoint | Set default value of date field to last day of the month

One of the things, that I needed to do recently is find a way to set the default value of a date field to the last day of the month.

Though some content were really helpful in getting me on the way to solving the problem, I thought I'd post the formula required to make it easier for others looking to do the same in the future.
What I wanted to do  The steps below describe what I wanted to achieve: User uploads a file into a document libraryA date column will automatically be populated with the date representing the end of the month (calculated based on the date the file was uploaded) How do we do this?
Open your column settings for your date fieldUnder the Additional Column Settings, set the default value option to Calculated Value
Enter the the formula below:

=(DATE(YEAR(TODAY()),MONTH(TODAY())+1,DAY("1-Apr-2008"))) - (1)Click save and that's all you need to do
What does the formula above do? The formula above is quite simple.
=(DATE(YEAR... | The date date function to …