# Data Base Update

**URL:** <https://forums.knack.com/t/data-base-update/12394>\
**Category:** Get Answers\
**Created:** [April 14, 2022, 12:03pm UTC](https://forums.knack.com/t/data-base-update/12394 "2022-04-14T12:03:36Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![David2](https://avatars.discourse-cdn.com/v4/letter/d/a87d85/32.png) [@David2](https://forums.knack.com/u/David2)\
**Post date:** [April 14, 2022, 12:03pm UTC](https://forums.knack.com/t/data-base-update/12394/1 "2022-04-14T12:03:36Z")

</div>

I have a Status field that compares the Current Date with a Due Date with two outcomes - On-Time or Late. Problem seems that unless there is record update, the Status field doesn’t change. I would like this Status field to stay up to date at all times. Am I missing something? Thanks.

---

<div class="post-metadata">

**Author:** ![PeterG](https://avatars.discourse-cdn.com/v4/letter/p/977dab/32.png) [@PeterG](https://forums.knack.com/u/PeterG)\
**Post date:** [April 14, 2022, 2:58pm UTC](https://forums.knack.com/t/data-base-update/12394/2 "2022-04-14T14:58:00Z")

</div>

That would probably require some custom JavaScript for an onTimer event. I haven’t seen anything like that in Knack.

---

<div class="post-metadata">

**Author:** ![KnackPros](https://sea2.discourse-cdn.com/flex020/user_avatar/forums.knack.com/knackpros/32/807_2.png) [@KnackPros](https://forums.knack.com/u/KnackPros)\
**Post date:** [April 15, 2022, 5:21am UTC](https://forums.knack.com/t/data-base-update/12394/3 "2022-04-15T05:21:52Z")

</div>

Hi David,

You can create a **Task** that updates the records daily.

If I understood your question correctly, you don’t want to update the Status field in real-time. What you’re saying (I think) is that your Status field is a calculated value and only updates when the records are updated. If that’s the case, then creating a daily Task will solve your issue.

---

<div class="post-metadata">

**Author:** ![David2](https://avatars.discourse-cdn.com/v4/letter/d/a87d85/32.png) [@David2](https://forums.knack.com/u/David2)\
**Post date:** [April 15, 2022, 11:21am UTC](https://forums.knack.com/t/data-base-update/12394/4 "2022-04-15T11:21:28Z")

</div>

OK thanks. That’s what I was thinking but I wanted an expert to weigh in on this. Much obliged.