# How to get correctly formatted Date when exporting BAQ results toi Excel

**URL:** <https://www.epiusers.help/t/how-to-get-correctly-formatted-date-when-exporting-baq-results-toi-excel/128956>\
**Category:** Epicor ERP 10\
**Tags:** baq\
**Created:** [September 3, 2025, 8:20am UTC](https://www.epiusers.help/t/how-to-get-correctly-formatted-date-when-exporting-baq-results-toi-excel/128956 "2025-09-03T08:20:36Z")\
**Posts on this page:** 1\
**Showing post:** 4

<div class="post-metadata">

**Author:** ![Briser](https://www.epiusers.help/user_avatar/www.epiusers.help/briser/32/74333_2.png) [@Briser](https://www.epiusers.help/u/Briser)\
**Post date:** [September 3, 2025, 11:07am UTC](https://www.epiusers.help/t/how-to-get-correctly-formatted-date-when-exporting-baq-results-toi-excel/128956/4 "2025-09-03T11:07:57Z")

</div>

I found a simple way to do this by virtue of another post:

> [@Date format in BAQ Calculated Field](https://www.epiusers.help/t/date-format-in-baq-calculated-field/37752):
>
> want this MM/DD/YY but keep on getting MM/DD/YYYY Thanks.

In my case I created a simple Convert(Varchar, mytable.myfield, 3) to get the UK format date dd/mm/yy and this shows up the same in Excel  
Thanks to Brandon Anderson for that one. @Banderson

---

_[View the full topic](https://www.epiusers.help/t/how-to-get-correctly-formatted-date-when-exporting-baq-results-toi-excel/128956)._