AugForums.com

An Acumatica User Group

  • Free
    • Start Here
    • Rolodex
    • Podcast
    • Blog
    • Forums
  • Paid
    • AugSQL
    • GI Course
    • GI Library
    • Consulting
  • Register
Acumatica Forums

By using this website, you agree to our Terms of Use (click here)

Forums
AUG Forums
Acumatica Report De...
Formatting a date m...
 
Notifications
Clear all

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

 
Acumatica Report Designer
Last Post by fozzie 8 years ago
3 Posts
2 Users
2 Reactions
4,563 Views
RSS
fozzie
Posts: 34
 fozzie
Topic starter
June 17, 2017 9:26 am
(@fozzie)
Trusted Member
Joined: 9 years ago

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.


2 Replies
John Doe Updated
Posts: 3193
 John Doe Updated
Admin
June 17, 2017 9:29 am
(@timrodman)
Famed Member
Joined: 10 years ago

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

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


Reply
mcraig reacted
fozzie
Posts: 34
 fozzie
Topic starter
June 17, 2017 9:31 am
(@fozzie)
Trusted Member
Joined: 9 years ago

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:


Reply
John Doe Updated reacted
Forum Jump:
  Previous Topic
Next Topic  
Forum Information
Recent Posts
Unread Posts
Tags
  • 12 Forums
  • 2,526 Topics
  • 10.9 K Posts
  • 35 Online
  • 2,410 Members
Our newest member: thollings
Latest Post: Attribute Input Mask
Forum Icons: Forum contains no unread posts Forum contains unread posts
Topic Icons: Not Replied Replied Active Hot Sticky Unapproved Solved Private Closed

Online Members

 No online members at the moment

Acumatica Forums

Terms of Use & Disclaimers :: Privacy Policy

Copyright © 2025 · AUG Forums, LLC. All rights reserved. This website is not owned, affiliated with, or endorsed by Acumatica, Inc.

‹›×

    ‹›×