# BAQ Widget Export to Excel Date Format

**URL:** <https://www.epiusers.help/t/baq-widget-export-to-excel-date-format/93367>\
**Category:** Kinetic ERP\
**Tags:** epicor\
**Created:** [August 12, 2022, 5:51pm UTC](https://www.epiusers.help/t/baq-widget-export-to-excel-date-format/93367 "2022-08-12T17:51:01Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![tse.dba](https://www.epiusers.help/user_avatar/www.epiusers.help/tse.dba/32/8690_2.png) [@tse.dba](https://www.epiusers.help/u/tse.dba)\
**Post date:** [August 12, 2022, 5:51pm UTC](https://www.epiusers.help/t/baq-widget-export-to-excel-date-format/93367/1 "2022-08-12T17:51:01Z")

</div>

Some users have BAQ widgets on there Epicor home page. These widgets have the ability to export to excel quickly. But I have noticed that date fields show a time when exported to excel. Is there are way to format this widget or BAQ so that is doesn’t do that. These date fields don’t even have the ability to input a time.

Id rather not have to keep changing the format in Excel each time, or at least that is the user’s preference.

 ![image](https://www.epiusers.help/uploads/default/original/3X/7/0/70216cab82e710e36c35e3dcc558d031c4c9cd86.png)

![image](https://www.epiusers.help/uploads/default/original/3X/f/6/f612595e87597206f492e4ee68650c3379b8bbb5.png)

---

<div class="post-metadata">

**Author:** ![NateS](https://www.epiusers.help/user_avatar/www.epiusers.help/nates/32/18519_2.png) [@NateS](https://www.epiusers.help/u/NateS)\
**Post date:** [August 12, 2022, 6:31pm UTC](https://www.epiusers.help/t/baq-widget-export-to-excel-date-format/93367/2 "2022-08-12T18:31:42Z")

</div>

In your BAQ, go to Display Fields. Find your date field. in the Format column it probably says {datetime}. Change it to {date}. Save your BAQ and try again.  
Good luck!

---

<div class="post-metadata">

**Author:** ![tse.dba](https://www.epiusers.help/user_avatar/www.epiusers.help/tse.dba/32/8690_2.png) [@tse.dba](https://www.epiusers.help/u/tse.dba)\
**Post date:** [August 12, 2022, 7:46pm UTC](https://www.epiusers.help/t/baq-widget-export-to-excel-date-format/93367/3 "2022-08-12T19:46:04Z")

</div>

No go. Epicor Support is writing it up as PRB

---

<div class="post-metadata">

**Author:** ![Lingsharr](https://www.epiusers.help/user_avatar/www.epiusers.help/lingsharr/32/74425_2.png) [@Lingsharr](https://www.epiusers.help/u/Lingsharr)\
**Post date:** [March 21, 2024, 3:11pm UTC](https://www.epiusers.help/t/baq-widget-export-to-excel-date-format/93367/4 "2024-03-21T15:11:33Z")

</div>

I am having the same issue. In my BAQ, in display fields, I can see it already says {date} but when I export it still shows up as 2024-03-19T00:00:00

Do you know where else I can try to fix this?? Thank you!

 ![image](https://www.epiusers.help/uploads/default/original/3X/9/a/9aaebf5f4a33928dbe2fba9084fd63bec9a82278.png)

![image](https://www.epiusers.help/uploads/default/original/3X/2/0/2080d626d2803cbd5b9d60f67cf6a0e4134a291c.png)

---

<div class="post-metadata">

**Author:** ![cnewbould](https://www.epiusers.help/user_avatar/www.epiusers.help/cnewbould/32/78143_2.png) [@cnewbould](https://www.epiusers.help/u/cnewbould)\
**Post date:** [March 28, 2024, 1:45pm UTC](https://www.epiusers.help/t/baq-widget-export-to-excel-date-format/93367/5 "2024-03-28T13:45:16Z")

</div>

Could you convert the date to a string in a calculated field and format it correctly?

> **[SQL Server CONVERT() Function](https://www.w3schools.com/sql/func_sqlserver_convert.asp)**
>
> W3Schools offers free online tutorials, references and exercises in all the major languages of the web. Covering popular subjects like HTML, CSS, JavaScript, Python, SQL, Java, and many, many more.