From a6be0a86c7d6a9d7d8845ad04bd22f3329f94e62 Mon Sep 17 00:00:00 2001
From: larssandergreen <lars@wildsight.ca>
Date: Fri, 12 May 2023 23:55:07 -0600
Subject: [PATCH] Export SearchKit spreadsheet date in SQL format

---
 .../Civi/Api4/Action/SearchDisplay/AbstractRunAction.php      | 4 +++-
 1 file changed, 3 insertions(+), 1 deletion(-)

diff --git a/ext/search_kit/Civi/Api4/Action/SearchDisplay/AbstractRunAction.php b/ext/search_kit/Civi/Api4/Action/SearchDisplay/AbstractRunAction.php
index 476b116109..b438c72b01 100644
--- a/ext/search_kit/Civi/Api4/Action/SearchDisplay/AbstractRunAction.php
+++ b/ext/search_kit/Civi/Api4/Action/SearchDisplay/AbstractRunAction.php
@@ -787,7 +787,9 @@ abstract class AbstractRunAction extends \Civi\Api4\Generic\AbstractAction {
 
       case 'Date':
       case 'Timestamp':
-        $formatted = \CRM_Utils_Date::customFormat($rawValue);
+        if (!(isset($this->format) && in_array($this->format, ['csv', 'xlsx', 'ods']))) {
+          $formatted = \CRM_Utils_Date::customFormat($rawValue);
+        }
     }
 
     return $formatted;
-- 
2.25.1