www.hkvforums.com

Hi,
I have a datetime field type Auto-Update Value = CurrentDateTime().
how do I update my datetime data and it doesn't change.
datetime changes only occur when adding new data

Thank You

if (CurrentPageID()== "edit"){
        if (empty($this->date_in->DBValue)){
            $rsnew["date_in"] = CurrentDateTime();
        } else {
            // If the value already exists there is no need to update it again
        }
    }

Rachman wrote:

if (empty($this->date_in->DBValue)){

You should check $rsold["date_in"] instead.

noted, thank you