# Calculated date shows with time in mail

**URL:** <https://community.triggre.com/t/calculated-date-shows-with-time-in-mail/121>\
**Category:** Support\
**Created:** [November 17, 2020, 1:31pm UTC](https://community.triggre.com/t/calculated-date-shows-with-time-in-mail/121 "2020-11-17T13:31:00Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Unknown](https://yyz1.discourse-cdn.com/flex035/user_avatar/community.triggre.com/unknown/32/31_2.png) [@Unknown](https://community.triggre.com/u/Unknown)\
**Post date:** [November 17, 2020, 1:31pm UTC](https://community.triggre.com/t/calculated-date-shows-with-time-in-mail/121/1 "2020-11-17T13:31:00Z")

</div>

Hello,

I have a flow that calculates a date (date A + 1 year). When I include that date in a mail message, it shows the date and the time:

“kunt u dit uiterlijk op 03-10-2020, 00:00 doorgeven”.

Hoe do I get rid of the time label?

Data A is a date field in a data, not a date/time field.

---

<div class="post-metadata">

**Author:** ![Unknown](https://yyz1.discourse-cdn.com/flex035/user_avatar/community.triggre.com/unknown/32/31_2.png) [@Unknown](https://community.triggre.com/u/Unknown)\
**Post date:** [November 17, 2020, 1:31pm UTC](https://community.triggre.com/t/calculated-date-shows-with-time-in-mail/121/2 "2020-11-17T13:31:05Z")

</div>

I created a work around: a Data (Datumbuffer) with two fields: Date and Secquence.

1. After the calculation I create a record with the calculated date.
2. Then I do a Look up for that record (sorted on the Sequence field, last first).
3. Then I use that date in the mail text.

---

<div class="post-metadata">

**Author:** ![Triggre](https://yyz1.discourse-cdn.com/flex035/user_avatar/community.triggre.com/triggre/32/14_2.png) [@Triggre](https://community.triggre.com/u/Triggre)\
**Post date:** [November 17, 2020, 1:31pm UTC](https://community.triggre.com/t/calculated-date-shows-with-time-in-mail/121/3 "2020-11-17T13:31:47Z")

</div>

Good to see you already found a creative solution. Another solution could be the following:

A date consists of 10 charachters (2 days, 2 months, 4 years, and 2 dashes).

First create a calculation to Combine A with B to make your date convert to text (you can fill out nothing at B)

By using the function “Cut A from B for N charachters” you can “cut Date from 0 for 10 charachters”. That will result in just the date.

This is considered a defect, so we will pick this up.

---

<div class="post-metadata">

**Author:** ![Triggre](https://yyz1.discourse-cdn.com/flex035/user_avatar/community.triggre.com/triggre/32/14_2.png) [@Triggre](https://community.triggre.com/u/Triggre)\
**Post date:** [October 21, 2021, 1:07pm UTC](https://community.triggre.com/t/calculated-date-shows-with-time-in-mail/121/4 "2021-10-21T13:07:23Z")

</div>



---

<div class="post-metadata">

**Author:** ![Triggre](https://yyz1.discourse-cdn.com/flex035/user_avatar/community.triggre.com/triggre/32/14_2.png) [@Triggre](https://community.triggre.com/u/Triggre)\
**Post date:** [October 21, 2021, 1:07pm UTC](https://community.triggre.com/t/calculated-date-shows-with-time-in-mail/121/5 "2021-10-21T13:07:26Z")

</div>