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