Attached is a screenshot of a database table called FRACK.
I'm looking for help creating a SQL update statement which would compare timestamps in columns RACKED and CHILLROOMSCAN. If the CHILLROOMSCAN is an earlier date than the RACKED date, I would like to increment the CHILLROOMSCAN value by 1 day, leaving the hour/min/sec AM/PM details unchanged.
If the CHILLROOMSCAN value is the same date or later than the RACKED value, then no change should take place.
Can someone help?