# Date field with multiple dates

**URL:** <https://community.fibery.io/t/date-field-with-multiple-dates/4216>\
**Category:** Get Help\
**Created:** [March 31, 2023, 7:30pm UTC](https://community.fibery.io/t/date-field-with-multiple-dates/4216 "2023-03-31T19:30:17Z")\
**Posts on this page:** 10\
**Page:** 1

<div class="post-metadata">

**Author:** ![gomocoop](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/gomocoop/32/6349_2.png) [@gomocoop](https://community.fibery.io/u/gomocoop)\
**Post date:** [March 31, 2023, 7:30pm UTC](https://community.fibery.io/t/date-field-with-multiple-dates/4216/1 "2023-03-31T19:30:17Z")

</div>

Hello!

I have a database for tasks, and there’s a field called “task completion forecast” where the person adds a date that corresponds to when they think they can finish the task. But many times we have to update this date, and I wanted to keep a track record of all the previous dates… the date field only allows me to have one date.

Any idea?

Thanks!

---

<div class="post-metadata">

**Author:** ![Chr1sG](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/chr1sg/32/3941_2.png) [@Chr1sG](https://community.fibery.io/u/Chr1sG)\
**Post date:** [March 31, 2023, 7:44pm UTC](https://community.fibery.io/t/date-field-with-multiple-dates/4216/2 "2023-03-31T19:44:21Z")

</div>

To what use will you put the information on previous date values?  
If you want to see trends, then perhaps you don’t need a field that can store multiple dates, but can make use of a report view to see how the date value has changed over time?

---

<div class="post-metadata">

**Author:** ![Matt\_Blais](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/matt_blais/32/1464_2.png) [@Matt\_Blais](https://community.fibery.io/u/Matt_Blais)\
**Post date:** [April 1, 2023, 7:35pm UTC](https://community.fibery.io/t/date-field-with-multiple-dates/4216/3 "2023-04-01T19:35:02Z")

</div>

What Fibery feature allows reporting on how a field’s value has changed over time?

Or is that something we would need to automate?

---

<div class="post-metadata">

**Author:** ![Chr1sG](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/chr1sg/32/3941_2.png) [@Chr1sG](https://community.fibery.io/u/Chr1sG)\
**Post date:** [April 1, 2023, 7:48pm UTC](https://community.fibery.io/t/date-field-with-multiple-dates/4216/4 "2023-04-01T19:48:30Z")

</div>

Historical reports:  
[https://the.fibery.io/@public/User\_Guide/Guide/Reports-58#Guide/Current-vs-historical-data-168](https://the.fibery.io/@public/User_Guide/Guide/Reports-58#Guide/Current-vs-historical-data-168)

---

<div class="post-metadata">

**Author:** ![Matt\_Blais](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/matt_blais/32/1464_2.png) [@Matt\_Blais](https://community.fibery.io/u/Matt_Blais)\
**Post date:** [April 1, 2023, 9:37pm UTC](https://community.fibery.io/t/date-field-with-multiple-dates/4216/5 "2023-04-01T21:37:36Z")

</div>

Thanks!

FYI, the “[Current vs historical data](https://the.fibery.io/@public/User_Guide/Guide/Current-vs-historical-data-168)” link in that doc is not clickable, but I found the content through Search.

---

<div class="post-metadata">

**Author:** ![gomocoop](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/gomocoop/32/6349_2.png) [@gomocoop](https://community.fibery.io/u/gomocoop)\
**Post date:** [April 4, 2023, 1:06pm UTC](https://community.fibery.io/t/date-field-with-multiple-dates/4216/6 "2023-04-04T13:06:15Z")

</div>

A report would be nice! But could it be shown as a field inside the entities of task? That would be more organized…

---

<div class="post-metadata">

**Author:** ![Chr1sG](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/chr1sg/32/3941_2.png) [@Chr1sG](https://community.fibery.io/u/Chr1sG)\
**Post date:** [April 4, 2023, 1:15pm UTC](https://community.fibery.io/t/date-field-with-multiple-dates/4216/7 "2023-04-04T13:15:16Z")

</div>

> [@gomocoop](#):
>
> could it be shown as a field inside the entities of task?

Do you mean that the history of a field’s date value could be shown as another field? 🤔

I don’t think we would ever introduce fields which merely showed the history of another field…

@Matt_Blais I’m not sure what you mean with this:

> [@Matt\_Blais](#):
>
> FYI, the “[Current vs historical data](https://the.fibery.io/@public/User_Guide/Guide/Current-vs-historical-data-168)” link in that doc is not clickable, but I found the content through Search.

When I click on the link I embedded in my previous message, I see the two user guides side-by-side:  
 ![firefox_vmn7gAX1Q6](https://us1.discourse-cdn.com/flex020/uploads/fibery/original/2X/6/62b99e17c9027c2d25f590415976671a22fddba3.gif)

Which link are you referring to?

---

<div class="post-metadata">

**Author:** ![gomocoop](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/gomocoop/32/6349_2.png) [@gomocoop](https://community.fibery.io/u/gomocoop)\
**Post date:** [April 4, 2023, 2:02pm UTC](https://community.fibery.io/t/date-field-with-multiple-dates/4216/8 "2023-04-04T14:02:05Z")

</div>

Yes! Kind of.

For example, there ir a task and the person said: “I can do it by April 1st”. Then I add on the date field of the task: April 1st.  
Then, on April 1st, I contacted them and they said: “Oh, I’m delayed, let’s put a new date, April 5th”. Then I changed the date field to April 5th.  
And so on (I work with volunteers, so this happens sometimes).

In order to have an idea of how many times that date has been changed, and to which values, I would like to have a field (formula, maybe) that would show the history of the dates… Does that make sense?

---

<div class="post-metadata">

**Author:** ![Chr1sG](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/chr1sg/32/3941_2.png) [@Chr1sG](https://community.fibery.io/u/Chr1sG)\
**Post date:** [April 4, 2023, 3:24pm UTC](https://community.fibery.io/t/date-field-with-multiple-dates/4216/9 "2023-04-04T15:24:59Z")

</div>

Unfortunately, there’s no quick and easy way to do what you’re asking for. The options are:

- manually review the activity log (or the audit log) to see what changes have been made
- design an automation that appends to a text field the latest value every time the date field value is changed
- add a relation field to a new type (called log) and create a new log entry every time the date (or in fact any field) is changed

---

<div class="post-metadata">

**Author:** ![Matt\_Blais](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/matt_blais/32/1464_2.png) [@Matt\_Blais](https://community.fibery.io/u/Matt_Blais)\
**Post date:** [April 4, 2023, 4:37pm UTC](https://community.fibery.io/t/date-field-with-multiple-dates/4216/10 "2023-04-04T16:37:24Z")

</div>

> [@Chr1sG](#):
>
> @Matt_Blais I’m not sure what you mean with this:
> 
> > [@Matt\_Blais](#):
> >
> > FYI, the “[Current vs historical data](https://the.fibery.io/@public/User_Guide/Guide/Current-vs-historical-data-168)” link in that doc is not clickable, but I found the content through Search.
> 
> When I click on the link I embedded in my previous message, I see the two user guides side-by-side:

It’s working for me now 😂 of course - probably just Chrome/plugin temporary insanity.
