Formatting a date month with leading zeros in Acumatica Report Designer - Acumatica Report Designer

RE: Formatting a date month with leading zeros in Acumatica Report Designer

fozzie — Sat, 17 Jun 2017 14:31:32 +0000

I didn't think to mention that I also want two digits for the days so that first code is exactly what I was looking for.

Now my dates look much better:

https://i.imgur.com/sjoLK5l.png

RE: Formatting a date month with leading zeros in Acumatica Report Designer

Tim Rodman — Sat, 17 Jun 2017 14:29:43 +0000

Hi Fozzie,

Try going to the properties on the field and in the Appearance section put the following code in the Format field:

MM/dd/yyyy

https://i.imgur.com/ndnf3Eo.png

Note that this code will also put leading zeros in front of the day as well. If you want only the single digit days, then you can use this code:

MM/d/yyyy

Formatting a date month with leading zeros in Acumatica Report Designer

fozzie — Sat, 17 Jun 2017 14:26:55 +0000

Hi Everyone,

Is it possible to format a date field in Report Designer to display a leading zero in front of the month (except for October, November, and December of course since they are already two digits)?

My dates don't show the leading zero.

https://i.imgur.com/ks9839E.png