# Dates format changes when pull attachment (XLXS)

**URL:** <https://community.parabola.io/t/dates-format-changes-when-pull-attachment-xlxs/2707>\
**Category:** Ask a question\
**Created:** [April 3, 2023, 9:03am UTC](https://community.parabola.io/t/dates-format-changes-when-pull-attachment-xlxs/2707 "2023-04-03T09:03:55Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Ahmet\_Shamiev](https://avatars.discourse-cdn.com/v4/letter/a/f9ae1b/32.png) [@Ahmet\_Shamiev](https://community.parabola.io/u/Ahmet_Shamiev)\
**Post date:** [April 3, 2023, 9:03am UTC](https://community.parabola.io/t/dates-format-changes-when-pull-attachment-xlxs/2707/1 "2023-04-03T09:03:55Z")

</div>

Hi guys,

I pull data from the email attachment, and the file is in .xlsx format. There are numerous dates fields inside the file, and in mail these files have a MM-DD-YYYY format (e.g. 3/31/2023), however, after pulling information into the flow, even in the attachement module, the dates format fields changes to MM-DD-YY (e.g.3/31/23) which must not be in this way and this breaks our next steps.

Interestingly, the Format Date module couldn’t improve it cause it can not recognize such type of date format (e.g.3/31/23).

Did anyone encounter with such issues before and how did you manage this?

Thanks,

 ![Screen Shot 2023-04-03 at 3.02.11 PM](https://us1.discourse-cdn.com/flex020/uploads/parabola/original/2X/f/fb50b03c445122d823d119409b150bffe0326676.png)

---

<div class="post-metadata">

**Author:** ![Emory\_Stainbrook](https://sea2.discourse-cdn.com/flex020/user_avatar/community.parabola.io/emory_stainbrook/32/1772_2.png) [@Emory\_Stainbrook](https://community.parabola.io/u/Emory_Stainbrook)\
**Post date:** [April 3, 2023, 4:31pm UTC](https://community.parabola.io/t/dates-format-changes-when-pull-attachment-xlxs/2707/2 "2023-04-03T16:31:13Z")

</div>

Hi @Ahmet_Shamiev - Happy to help! If you set the starting date format in the Format Date step as M/DD/YY are you seeing the step recognize that date formatting? You’ll need to type this format directly into the field under the dropdown under Starting Format:

![Screen Shot 2023-04-03 at 12.30.25 PM](https://us1.discourse-cdn.com/flex020/uploads/parabola/original/2X/9/90f2d0c18ab3afab16ef13b1b69e3bcb52758d0e.png)

---

<div class="post-metadata">

**Author:** ![Ahmet\_Shamiev](https://avatars.discourse-cdn.com/v4/letter/a/f9ae1b/32.png) [@Ahmet\_Shamiev](https://community.parabola.io/u/Ahmet_Shamiev)\
**Post date:** [April 4, 2023, 3:24am UTC](https://community.parabola.io/t/dates-format-changes-when-pull-attachment-xlxs/2707/3 "2023-04-04T03:24:21Z")

</div>

Hi @Emory_Stainbrook , thanks for sharing this. This works perfect!! 😃