How precise should the time be when using:
IF(COMPLETE,DATETIME_FORMAT(SET_TIMEZONE(NOW(),‘America/Chicago’) ,‘M/DD/YYYY h:mm A’),"")
I’m trying to get a current time stamp (including h:mm), but the Completed Time is updating all rows every 5-7 minut...
