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 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)
RobElliott This won't seem to work if the additional months make it greater than 12 though.
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?
