From 5bcc7a4ccbb360794669a098b48d8eb3dcf77119 Mon Sep 17 00:00:00 2001
From: Joe Hunt <joe.hunt.consulting@gmail.com>
Date: Fri, 4 Oct 2019 09:48:59 +0200
Subject: [PATCH] Additional Transaction Date presence check

---
 admin/db/transactions_db.inc | 3 ++-
 1 file changed, 2 insertions(+), 1 deletion(-)

diff --git a/admin/db/transactions_db.inc b/admin/db/transactions_db.inc
index f7d2d295..466ded81 100644
--- a/admin/db/transactions_db.inc
+++ b/admin/db/transactions_db.inc
@@ -31,7 +31,8 @@ function get_sql_for_view_transactions($filtertype, $from, $to, &$trans_ref)
 		$sql .= " ,t.$trans_ref as ref ";
 	else
 		$sql .= ", r.reference as ref";
- 	$sql .= ",t.$trans_date as trans_date";
+	if ($trans_date)
+		$sql .= ",t.$trans_date as trans_date";
  	if ($type_name)
 		$sql .= ", t.$type_name as type";
 	$sql .= " FROM $table_name t LEFT JOIN ".TB_PREF."voided v ON"
-- 
2.30.2