1 files changed, 12 insertions, 0 deletions
diff --git a/python/report_ops/misc.py b/python/report_ops/misc.py
index 757169fe..0db842bd 100644
--- a/python/report_ops/misc.py
+++ b/python/report_ops/misc.py
@@ -1,6 +1,8 @@
 import pathlib
 import datetime
+
 from serenitas.utils.env import DAILY_DIR
+from serenitas.utils.exchange import ExchangeMessage
 
 _recipients = {
     "ISOSEL": (
@@ -119,3 +121,13 @@ def dt_from_citco(filename, file_tag, dt_format):
     return datetime.datetime.strptime(
         filename.removesuffix(".csv").removeprefix(file_tag), dt_format
     )
+
+
+def em_date_filter(em: ExchangeMessage, start: datetime.date, end: datetime.date):
+    start = datetime.datetime.combine(start, datetime.time.min).replace(
+        tzinfo=em._account.default_timezone
+    )
+    end = datetime.datetime.combine(end, datetime.time.max).replace(
+        tzinfo=em._account.default_timezone
+    )
+    return {"datetime_received__gte": start, "datetime_received__lte": end}