X-Git-Url: http://git.roojs.org/?p=Pman.Core;a=blobdiff_plain;f=DataObjects%2FCore_curr_rate.php;h=232ecbbfadd360fb2c149dbe2898852b25b8de4e;hp=37e2bf8653aac47c2f2178584f20f96c51accf5f;hb=b96bf0a85d55e7874567133370205340a568f5f2;hpb=7ad8302e0542a90efdf41fd8f1a67256be3ab49b

diff --git a/DataObjects/Core_curr_rate.php b/DataObjects/Core_curr_rate.php
index 37e2bf86..232ecbbf 100644
--- a/DataObjects/Core_curr_rate.php
+++ b/DataObjects/Core_curr_rate.php
@@ -142,7 +142,9 @@ class Pman_Core_DataObjects_Core_curr_rate extends DB_DataObject
         
         $r = DB_DataObject::factory('core_curr_rate');
         $r->curr = $cur;
-        $r->whereAdd('from_dt < when_dt
+        $r->whereAdd("from_dt < '" . date('Y-m-d H:i:s', strtotime($when)) . "'");
+        $r->orderBy('to_dt ASC');
+        $r->limit(1);
         
     }