Sharepoint calculate field – Digital Transformation

How to calculate the reminder date automatically and display the item based on the month & year of its reminder date (Part-2)

August 2, 2017
Amin Talebikahangi
SharePoint

Part 2: Steps to display the item based on the month & year of its reminder date

1. Create 2 more columns with the steps in Part 1 (Step 1 – 5). Then, named the 2 columns as “Reminder Start Month” and “Reminder End Month” with the formula:-

Reminder Start Month (First day)	Reminder End Month (Last day)
=DATE(YEAR([ReminderDate]),MONTH([Reminder Date]),1)	=DATE(YEAR([Reminder Date]),MONTH([Reminder Date])+1,1)-1

How to calculate the reminder date automatically and display the item based on the month & year of its reminder date (Part-1)

July 26, 2017
Amin Talebikahangi
SharePoint

One of our customer required to calculate the item’s reminder date automatically based on the item’s expiry date and display the item that its reminder date is placed on current month & year.

The reminder date will be the date which is 3 months before the expiry date. For example:-