many, many changes

1 files changed, 6 insertions, 2 deletions

diff --git a/backend/src/queries/budget_updates/get_most_recent_with_category_id.rs b/backend/src/queries/budget_updates/get_most_recent_with_category_id.rs
index a52e592..4753092 100644
--- a/backend/src/queries/budget_updates/get_most_recent_with_category_id.rs
+++ b/backend/src/queries/budget_updates/get_most_recent_with_category_id.rs
@@ -1,5 +1,8 @@
-use crate::schema::budget_updates::{
-    self as budget_updates_schema, dsl::budget_updates as budget_updates_table,
+use crate::{
+    models::date_time_utc::DateTimeUtc,
+    schema::budget_updates::{
+        self as budget_updates_schema, dsl::budget_updates as budget_updates_table,
+    },
 };
 use diesel::{dsl::max, result::Error, ExpressionMethods, QueryDsl, RunQueryDsl, SqliteConnection};
 
@@ -10,5 +13,6 @@ pub fn get_most_recent_budget_update_date_with_category_id(
     budget_updates_table
         .select(max(budget_updates_schema::date))
         .filter(budget_updates_schema::category_id.eq(category_id))
+        .filter(budget_updates_schema::date.le(DateTimeUtc::now().to_day_str()))
         .first(connection)
 }