Hi,
Bit of a brain twister this one!
I have these three columns within a SharePoint list:
"Next Review Date" is a calculated column that takes the value from "Last review date" and add the number of years shown in "Review Frequency" column.
The formula I am using is:
=DATE(YEAR([Last Review Date])+[Review Frequency],MONTH([Last Review Date]),DAY([Last Review Date]))
This works as you can see from screenshot; the next stage is that I am using Flow to look at the "Next review date" and send out an email if the date has passed. The email contains a HTML table that has the "Next review date" displayed
I have "Get files (properties only)" control on the Flow, if I look out the output from the control the date for the column "Next Review Date" is an hour out which makes the date a whole day out:
Because this date is wrong the date the table in the email displays incorrect information. The column setting in SharePoint are set to "Date Only" but as you can see the time is still showing.
I am sure this is probably some UTC vs UTC+1 (which is my time zone) issue but is there anything I can do in Flow to manipulate the date so it's correct?
Thanks in advance
Rob
