BAQ vs Dashboard date format issue

Epicor ERP 10
1

Hi,

I created a BAQ with a date column, I use a suggested format which is yyyy-MM-dd. When I run my BAQ, the date column display the data correctly matching the format I use. When I use my BAQ in a dashboard, the format of the date column become YYYY-MM-DD which display ma data incorrectly, any though???

Regards
Al

2

Good morning!
Try this,

dateformat
dateformat784×648 118 KB

Customize your dashboard, and click on your grid. In Properties there is a columns list. Click the drop down and find the field you want to change the format for.
I hope this helps!
Nate

3

Another option would be to format your date as a string in the BAQ.

4

Thank’s Doug :blush:

5

Thank’s Nate :blush: