# Date format in BAQ Calculated Field

**URL:** <https://www.epiusers.help/t/date-format-in-baq-calculated-field/37752>\
**Category:** Epicor ERP 9\
**Created:** [March 23, 2017, 8:26pm UTC](https://www.epiusers.help/t/date-format-in-baq-calculated-field/37752 "2017-03-23T20:26:13Z")\
**Posts on this page:** 10\
**Page:** 1

<div class="post-metadata">

**Author:** ![MiguelS](https://www.epiusers.help/user_avatar/www.epiusers.help/miguels/32/99_2.png) [@MiguelS](https://www.epiusers.help/u/MiguelS)\
**Post date:** [March 23, 2017, 8:26pm UTC](https://www.epiusers.help/t/date-format-in-baq-calculated-field/37752/1 "2017-03-23T20:26:13Z")

</div>

want this MM/DD/YY but keep on getting MM/DD/YYYY

Thanks.

---

<div class="post-metadata">

**Author:** ![Banderson](https://www.epiusers.help/user_avatar/www.epiusers.help/banderson/32/50875_2.png) [@Banderson](https://www.epiusers.help/u/Banderson)\
**Post date:** [March 23, 2017, 8:36pm UTC](https://www.epiusers.help/t/date-format-in-baq-calculated-field/37752/2 "2017-03-23T20:36:36Z")

</div>

Can you paste calculation? I think you need a ,1) at the end for that format according to this website.

> **[SQL Server DateTime Formatting](http://www.blackwasp.co.uk/sqldatetimeformats.aspx)**
>
> Usually the formatting of a DateTime value into a more readable date and time is dealt with by the client application. However, there are some situations were it is useful to convert a DateTime into a formatted character string within a SQL...

---

<div class="post-metadata">

**Author:** ![MiguelS](https://www.epiusers.help/user_avatar/www.epiusers.help/miguels/32/99_2.png) [@MiguelS](https://www.epiusers.help/u/MiguelS)\
**Post date:** [March 23, 2017, 8:43pm UTC](https://www.epiusers.help/t/date-format-in-baq-calculated-field/37752/3 "2017-03-23T20:43:27Z")

</div>

I changed the title to BAQ Calculated Field.

---

<div class="post-metadata">

**Author:** ![Banderson](https://www.epiusers.help/user_avatar/www.epiusers.help/banderson/32/50875_2.png) [@Banderson](https://www.epiusers.help/u/Banderson)\
**Post date:** [March 23, 2017, 9:03pm UTC](https://www.epiusers.help/t/date-format-in-baq-calculated-field/37752/4 "2017-03-23T21:03:26Z")

</div>

convert(varchar, PartTran.TranDate, 1)

![](https://epiusers.help/uploads/default/original/2X/9/96e3f9e9d85242c208de5567d7b2f2e6fa02fc1b.png)

![](https://epiusers.help/uploads/default/original/2X/d/de5307f47a6322493fc77feba381235245792070.png)

---

<div class="post-metadata">

**Author:** ![Banderson](https://www.epiusers.help/user_avatar/www.epiusers.help/banderson/32/50875_2.png) [@Banderson](https://www.epiusers.help/u/Banderson)\
**Post date:** [March 23, 2017, 9:04pm UTC](https://www.epiusers.help/t/date-format-in-baq-calculated-field/37752/5 "2017-03-23T21:04:26Z")

</div>

or just do this

 ![](https://epiusers.help/uploads/default/original/2X/8/88d4b2a866c03f44d4b92c560fec8cb09f107671.png)

---

<div class="post-metadata">

**Author:** ![MiguelS](https://www.epiusers.help/user_avatar/www.epiusers.help/miguels/32/99_2.png) [@MiguelS](https://www.epiusers.help/u/MiguelS)\
**Post date:** [March 23, 2017, 9:04pm UTC](https://www.epiusers.help/t/date-format-in-baq-calculated-field/37752/6 "2017-03-23T21:04:38Z")

</div>

I am on progress.

Stuck at this.

String(Month(Checkhed.CheckDate),“99”) + “/” + String(Day(Checkhed.CheckDate),“99”) + “/” + String(Year(Checkhed.CheckDate),“99”)

![](https://epiusers.help/uploads/default/original/2X/c/cd3d60865b3a50b4efe48b83840e9820b8e1ed01.jpg)

---

<div class="post-metadata">

**Author:** ![Banderson](https://www.epiusers.help/user_avatar/www.epiusers.help/banderson/32/50875_2.png) [@Banderson](https://www.epiusers.help/u/Banderson)\
**Post date:** [March 23, 2017, 9:05pm UTC](https://www.epiusers.help/t/date-format-in-baq-calculated-field/37752/7 "2017-03-23T21:05:55Z")

</div>

Never mind then. I didn’t notice you were on E9

---

<div class="post-metadata">

**Author:** ![MiguelS](https://www.epiusers.help/user_avatar/www.epiusers.help/miguels/32/99_2.png) [@MiguelS](https://www.epiusers.help/u/MiguelS)\
**Post date:** [March 23, 2017, 9:13pm UTC](https://www.epiusers.help/t/date-format-in-baq-calculated-field/37752/8 "2017-03-23T21:13:09Z")

</div>

No problem,thanks for the effort. I am working on E10 new install…but need to work on E9 Prog for another 7 months.

I got it though.

`String(Month(Checkhed.CheckDate),"99") + "/" + String(Day(Checkhed.CheckDate),"99") + "/" + LEFT-TRIM (String(Year(Checkhed.CheckDate),"9999"),"20")`

![](https://epiusers.help/uploads/default/original/2X/f/fc8c6a997cf041b65a2d4dd7da6b529f1ac2e504.jpg)

---

<div class="post-metadata">

**Author:** ![Banderson](https://www.epiusers.help/user_avatar/www.epiusers.help/banderson/32/50875_2.png) [@Banderson](https://www.epiusers.help/u/Banderson)\
**Post date:** [March 23, 2017, 10:05pm UTC](https://www.epiusers.help/t/date-format-in-baq-calculated-field/37752/9 "2017-03-23T22:05:16Z")

</div>

After looking at what you have to do for something that should be easy, I’m glad we’re on E-10. Glad you got it.

---

<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, 10:00am UTC](https://www.epiusers.help/t/date-format-in-baq-calculated-field/37752/10 "2025-09-03T10:00:24Z")

</div>

Great, thanks for this!