# Date Custom Fields in Custom Reports and Batch Operations

**URL:** <https://forum.manager.io/t/date-custom-fields-in-custom-reports-and-batch-operations/28879>\
**Category:** ideas\
**Created:** [June 20, 2020, 4:56pm UTC](https://forum.manager.io/t/date-custom-fields-in-custom-reports-and-batch-operations/28879 "2020-06-20T16:56:59Z")\
**Posts on this page:** 14\
**Page:** 1

<div class="post-metadata">

**Author:** ![Davide](https://avatars.discourse-cdn.com/v4/letter/d/258eb7/32.png) [@Davide](https://forum.manager.io/u/Davide)\
**Post date:** [June 20, 2020, 4:56pm UTC](https://forum.manager.io/t/date-custom-fields-in-custom-reports-and-batch-operations/28879/1 "2020-06-20T16:56:59Z")

</div>

There is a bug related to dates that afflict many aspects of Manager, ie Custom Fields / Custom Report / Batch Create / Batch Update.

The premise is that my preferences manager are:

![Screenshot_20200620-115054__01](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/3X/6/4/640ea9942206e7b7c82b7df6be04c870947e4f88.jpeg)

so my date format is dd/mm/yyyy and the same is in Excel.

Here comes the problems that are all linked:

1. custom reporting shows date of custom fields with a different date format;
2. when I export a list for batch update I get two different date format, a correct one for transaction date and wrong ones for custom fields. When I import them in excel, it automatically converts them in the correct format but with errors when the day is \<= 12 since it cannot distinguish which is the day and which is the month. When I import it back it completely messes up the dates;
3. when I export a list for batch update I have also problems with text custom fields. I use a custom field to store suppliers’ invoice numberings that are all in different formats. For example I can have 10/2020. When pasted into Excel they are converted into a date “Dec/2020” and so when imported beck I get this text messed up.
4. when I batch create some data I got the same prime as point 2 for dates in custom fields since it switches days and months if days are \<=12.

---

<div class="post-metadata">

**Author:** ![Tut](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/tut/32/3286_2.png) [@Tut](https://forum.manager.io/u/Tut)\
**Post date:** [June 20, 2020, 6:46pm UTC](https://forum.manager.io/t/date-custom-fields-in-custom-reports-and-batch-operations/28879/2 "2020-06-20T18:46:32Z")

</div>

I am putting this into bugs, but only for item #1. The others are behavior of Excel.

---

<div class="post-metadata">

**Author:** ![Davide](https://avatars.discourse-cdn.com/v4/letter/d/258eb7/32.png) [@Davide](https://forum.manager.io/u/Davide)\
**Post date:** [June 20, 2020, 7:57pm UTC](https://forum.manager.io/t/date-custom-fields-in-custom-reports-and-batch-operations/28879/3 "2020-06-20T19:57:50Z")

</div>

Once all custom.fields are formatted well there should not be any issue.

However, about point 3 you cannot say it’s an issue of Excel because it is a fundamental part of the process of butch update.

---

<div class="post-metadata">

**Author:** ![Tut](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/tut/32/3286_2.png) [@Tut](https://forum.manager.io/u/Tut)\
**Post date:** [June 20, 2020, 8:51pm UTC](https://forum.manager.io/t/date-custom-fields-in-custom-reports-and-batch-operations/28879/4 "2020-06-20T20:51:22Z")

</div>

> [@Davide](#):
>
> about point 3 you cannot say it’s an issue of Excel

My statement was based on your description:

> [@Davide](#):
>
> When pasted into Excel they are converted into a date “Dec/2020” and so when imported beck I get this text messed up.

Dec/2020 appeared because of action by Excel. That is not a date format recognized by Manager, so it naturally did not work when pasted back in. But if Excel did not misinterpret or translate the date into the Mon/YYYY format, you would have a recognizable date to paste back. That is not a bug in Manager. It is the result of Excel’s programming and Excel’s attempt to interpret something it may not understand correctly.

---

<div class="post-metadata">

**Author:** ![Davide](https://avatars.discourse-cdn.com/v4/letter/d/258eb7/32.png) [@Davide](https://forum.manager.io/u/Davide)\
**Post date:** [June 20, 2020, 10:56pm UTC](https://forum.manager.io/t/date-custom-fields-in-custom-reports-and-batch-operations/28879/5 "2020-06-20T22:56:33Z")

</div>

You are right. I’m not saying in any way that it’s Manager fault. But, since you cannot use something different from Excel for batch create/update, you cannot say that is not a bug.

Maybe adding a ’ before every string when it’s a text can solve the issue. Maybe it cannot be solved. But it’s worth a further investigation by @lubos in order to make batch create and update fully functional.

Otherwise batch functions will mess up data.

---

<div class="post-metadata">

**Author:** ![Tut](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/tut/32/3286_2.png) [@Tut](https://forum.manager.io/u/Tut)\
**Post date:** [June 20, 2020, 11:51pm UTC](https://forum.manager.io/t/date-custom-fields-in-custom-reports-and-batch-operations/28879/6 "2020-06-20T23:51:29Z")

</div>

I think it is an issue of Excel preferences and regional differences in its versions.

---

<div class="post-metadata">

**Author:** ![Patch](https://avatars.discourse-cdn.com/v4/letter/p/a183cd/32.png) [@Patch](https://forum.manager.io/u/Patch)\
**Post date:** [June 21, 2020, 12:04am UTC](https://forum.manager.io/t/date-custom-fields-in-custom-reports-and-batch-operations/28879/7 "2020-06-21T00:04:58Z")

</div>

Excel cell format allows settings the date to the format Manager recognises. The default date format in Excel can also be set but it normally maintains the date format imported data

---

<div class="post-metadata">

**Author:** ![MarV](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/marv/32/17451_2.png) [@MarV](https://forum.manager.io/u/MarV)\
**Post date:** [June 21, 2020, 1:16am UTC](https://forum.manager.io/t/date-custom-fields-in-custom-reports-and-batch-operations/28879/8 "2020-06-21T01:16:18Z")

</div>

> [@Davide](#):
>
> when I export a list for batch update I have also problems with text custom fields. I use a custom field to store suppliers’ invoice numberings that are all in different formats. For example I can have 10/2020. When pasted into Excel they are converted into a date “Dec/2020” and so when imported beck I get this text messed up.

Define that column in Excel as Text, not leaving default General, and Excel will not do any of his “automatic” transcription of data. I also have several fields like yours, and have been there where you are struggling now.  
Also for 2 and 4. Define by hand, text or date/time field and format of column. Don’t leave as general or something that excel should guess and do automation.

---

<div class="post-metadata">

**Author:** ![Davide](https://avatars.discourse-cdn.com/v4/letter/d/258eb7/32.png) [@Davide](https://forum.manager.io/u/Davide)\
**Post date:** [June 21, 2020, 5:15am UTC](https://forum.manager.io/t/date-custom-fields-in-custom-reports-and-batch-operations/28879/9 "2020-06-21T05:15:21Z")

</div>

Yes but it doesn’t work with two different date’s formats as it happens with custom fields. Excel changes the second one.

And then, the real problem happens when you put the dates back with batch update.

---

<div class="post-metadata">

**Author:** ![Davide](https://avatars.discourse-cdn.com/v4/letter/d/258eb7/32.png) [@Davide](https://forum.manager.io/u/Davide)\
**Post date:** [June 21, 2020, 5:30am UTC](https://forum.manager.io/t/date-custom-fields-in-custom-reports-and-batch-operations/28879/10 "2020-06-21T05:30:00Z")

</div>

Thanks. I’ll try it.

But it’s a solution only for point 3 under my point of view.

First of all because formally there should be only one date format: the one that I setup in Settings. This is clearly a bug as stated in point 1. What you do it’s a workaround.

But secondly and mainly… for dates what if you need to (re)calculate some them in a custom field in Excel with a particular formula? Or insert/update data in a new custom field’s column based on the date you have in another custom field? You need to set them as dates and consequently it will mess your dates when put back in Manager. Keep in mind that I’m talking mainly about batch operations where the main scope is to apply a massive update/creation of data reducing manual work.

---

<div class="post-metadata">

**Author:** ![MarV](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/marv/32/17451_2.png) [@MarV](https://forum.manager.io/u/MarV)\
**Post date:** [June 21, 2020, 9:37pm UTC](https://forum.manager.io/t/date-custom-fields-in-custom-reports-and-batch-operations/28879/11 "2020-06-21T21:37:01Z")

</div>

Yap, maybe it is bug in custom fields. I have no such field with date values to test. But nevertheless I would never let Excel autodetect important fields. You may define that custom field as Date, with proper format in excel and do calculations/formulas. But if you say so, than it is a bug. Can you paste a short report lines 5-6 for testing, and original data screen?

---

<div class="post-metadata">

**Author:** ![lubos](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/lubos/32/62798_2.png) [@lubos](https://forum.manager.io/u/lubos)\
**Post date:** [July 8, 2020, 9:57am UTC](https://forum.manager.io/t/date-custom-fields-in-custom-reports-and-batch-operations/28879/12 "2020-07-08T09:57:20Z")

</div>

In the initial implementation of custom fields, all custom fields were just text fields. Date and number types were kind of bolted on top of text fields. But internally all custom fields are still text fields. So these are not really bugs, just how the implementation works.

I have new implementation of custom fields in mind which will make date/number custom fields behave the same like similar built-in fields. This will resolve this issue and about 5 other topics in `ideas` category related to custom fields. So I think this is better suited to be in `ideas` category too.

---

<div class="post-metadata">

**Author:** ![Davide](https://avatars.discourse-cdn.com/v4/letter/d/258eb7/32.png) [@Davide](https://forum.manager.io/u/Davide)\
**Post date:** [July 8, 2020, 5:46pm UTC](https://forum.manager.io/t/date-custom-fields-in-custom-reports-and-batch-operations/28879/13 "2020-07-08T17:46:39Z")

</div>

Hope to see the full implementation of new custom fields very soon. I love the direction Manager is taking during the last few months even though I’m struggling with many problems.

---

<div class="post-metadata">

**Author:** ![Rajwani](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/rajwani/32/26724_2.png) [@Rajwani](https://forum.manager.io/u/Rajwani)\
**Post date:** [March 17, 2021, 11:01am UTC](https://forum.manager.io/t/date-custom-fields-in-custom-reports-and-batch-operations/28879/14 "2021-03-17T11:01:02Z")

</div>

> [@Davide](#):
>
> when I export a list for batch update I get two different date format, a correct one for transaction date and wrong ones for custom fields. When I import them in excel, it automatically converts them in the correct format but with errors when the day is \<= 12 since it cannot distinguish which is the day and which is the month. When I import it back it completely messes up the dates;

We are also facing the same issue with batch update particularly with date field not only for custom even voucher issue date.

I was thinking about the same as mentioned by @Tut

> [@Tut](#):
>
> I think it is an issue of Excel preferences

Whereas later statement clarifies its not about that.

> [@lubos](#):
>
> So these are not really bugs, just how the implementation works.

> [@lubos](#):
>
> I have new implementation of custom fields in mind which will make date/number custom fields behave the same like similar built-in fields. This will resolve this issue and about 5 other topics in `ideas` category related to custom fields. So I think this is better suited to be in `ideas` category too.

As the matter has already been taken up, we will appreciate your assistance and guidance to manage in between.

In addition, we recently witness that data have been entered in custom field and saved. Later, details were extracted through batch update for some reports and analysis and noticed some ambiguity in flow of information for validation a live system was referred again and surprising no details were view beside it shows empty. Just to revalidate, the exercise was done again unfortunately results of both exercises were same. I hope there is no reliance issue in data integrality.
