Forum Discussion
Using a Calculated Value for a Date/Time Column in SP List
RLUGO I can't see anything wrong with your formula; this worked for me:
=DATE(YEAR([Insurance Expiry Date]),MONTH([Insurance Expiry Date])+Months,DAY([Insurance Expiry Date]))So what result are you getting?
Rob
Los Gallardos
Intranet, SharePoint and Power Platform Manager (and classic 1967 Morris Traveller driver)
RLUGO no, it needs to be a calculated column. It won't work in the way you have done it with a date/time column.
Rob
Los Gallardos
Intranet, SharePoint and Power Platform Manager (and classic 1967 Morris Traveller driver)
RobElliott I'm looking to do something similar but I would like to create a reminder 1 week before the three months+ date. If i make it a calculated column though it doesn't show up as an option when I try to set the reminder in Automate. Anyway I can do it in a date column?
- I understand now. Thank you for your help!
