Good Day,
Need assistance on creating calculated column to calculate and get the correct completion date from the date updated in a Date column
if the time in the date is before 6:30 then it will give the output as yesterday date
E.g if 11/20/2020 05:30:00 Then the completion date will be 11/19/2020
if 11/20/2020 06:31:00 Then the completion date will be 11/20/2020
if 11/20/2020 06:30:00 Then the completion date will be 11/20/2020
if 11/20/2020 06:29:00 Then the completion date will be 11/19/2020
Thanks for your assistance,
Regards
SSJ011
