// Get a database connection
$db = Joomla\CMS\Factory::getDbo();
// Get the current logged-in user's data
$user = Joomla\CMS\Factory::getUser();
 
// Define the RSForm!Pro field name for the Date field
$formFieldName = 'Date'; // Change this to match the RSForm field name exactly
 
// Retrieve the RSForm!Pro Date field value safely
$submittedDate = Joomla\CMS\Factory::getApplication()->input->post->getString($formFieldName, '');
 
// Convert the date to a valid MySQL format if needed (YYYY-MM-DD)
if (!empty($submittedDate)) {
    $dateObject = DateTime::createFromFormat('d/m/Y', $submittedDate); // Adjust format as per RSForm!Pro output
    if ($dateObject) {
        $submittedDate = $dateObject->format('Y-m-d'); // Convert to MySQL format (YYYY-MM-DD)
    }
}
 
// Ensure we have a valid user and a valid date
if ($user->id && !empty($submittedDate)) {
    // Prepare the query
    $query = $db->getQuery(true)
        ->update($db->quoteName('#__comprofiler'))
        ->set($db->quoteName('cb_upgradeapplied') . ' = ' . $db->quote($submittedDate))
        ->where($db->quoteName('user_id') . ' = ' . (int) $user->id);
 
    // Execute the query
    $db->setQuery($query);
    $db->execute();
}