# problem with date aggregation

**URL:** <https://forum.servoy.com/t/problem-with-date-aggregation/8891>\
**Category:** Classic Servoy\
**Created:** [March 20, 2008, 9:42am UTC](https://forum.servoy.com/t/problem-with-date-aggregation/8891 "2008-03-20T09:42:06Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![irenem](https://avatars.discourse-cdn.com/v4/letter/i/977dab/32.png) [@irenem](https://forum.servoy.com/u/irenem)\
**Post date:** [March 20, 2008, 9:42am UTC](https://forum.servoy.com/t/problem-with-date-aggregation/8891/1 "2008-03-20T09:42:06Z")

</div>

I have a date field called sent\_date.  
I’ve created an aggregation max\_sent\_date.

When I look at those fields in a table the max\_sent\_date reports Wed Mar 19 23:51:42 CET 2008, but the highest value of sent\_date that I have in my table is Thu Mar 20 09:20:32 CET 2008.

Is that a bug?

---

<div class="post-metadata">

**Author:** ![ROCLASI](https://yyz2.discourse-cdn.com/flex010/user_avatar/forum.servoy.com/roclasi/32/4371_2.png) [@ROCLASI](https://forum.servoy.com/u/ROCLASI)\
**Post date:** [March 20, 2008, 12:18pm UTC](https://forum.servoy.com/t/problem-with-date-aggregation/8891/2 "2008-03-20T12:18:06Z")

</div>

Hi Irene,

When looking at the table you are not filtering on any field?  
I.e. did you do a load all records ?

---

<div class="post-metadata">

**Author:** ![irenem](https://avatars.discourse-cdn.com/v4/letter/i/977dab/32.png) [@irenem](https://forum.servoy.com/u/irenem)\
**Post date:** [March 20, 2008, 12:41pm UTC](https://forum.servoy.com/t/problem-with-date-aggregation/8891/3 "2008-03-20T12:41:09Z")

</div>

no, all records are loaded and visible

---

<div class="post-metadata">

**Author:** ![ROCLASI](https://yyz2.discourse-cdn.com/flex010/user_avatar/forum.servoy.com/roclasi/32/4371_2.png) [@ROCLASI](https://forum.servoy.com/u/ROCLASI)\
**Post date:** [March 20, 2008, 1:16pm UTC](https://forum.servoy.com/t/problem-with-date-aggregation/8891/4 "2008-03-20T13:16:13Z")

</div>

Hi Irene,

And you are sure that latest data is actually saved to the backend database and not still in Servoy’s cache? All aggregates are queried directly from the backend.  
I guess you can check by closing and opening the solution.
