Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP forum
Suggested answer

change check print date formate

Posted on by Microsoft Employee

We have a check that is pre printed with the first two numbers of the year.   There isn't a date format that doesn't have the month/date/year or a version of that.  In GP 2016 and printing an A/P check.  Can this format be altered someway so the month and day can print, then just the last two dates in the year.   But at least the month and date

Categories:
  • Suggested answer
    Mariano Gomez Profile Picture
    Mariano Gomez 26,225 on at
    RE: change check print date formate

    You will need to create a series of calculated fields in Report Writer: a) one to get the current month, b) one to get the day, c) one to retrieve the year as a 2-digit string, and d) finally, one to concatenate all pieces. 

    For the first 3, you can call the RW_DateToString() system user-defined function by passing the date and format, as follows:

    For the Month: (C) StrMonth

    RWConcatDate.png

    For the Day: (C) StrDay

    RWPaddedDay.png

    For the year: (C) StrYear

    RWPaddedYear.png

    You can now create the concatenated version of the date as needed, using whatever format you need: (C) ConcatDate

    RWConcatDate.png

    All you have left now is to drag the calculated field, (C) ConcatDate onto the report and align it to the best of your abilities to the physical check layout. If you are not familiar with Report Writer, please provide these instructions to your partner. They should be able to assist.

  • Suggested answer
    Nanook Software Profile Picture
    Nanook Software 587 on at
    RE: change check print date formate

    Yes, the date format is based on the computer region settings (Short Date)...

    1205.2.png

    1205.2.png

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Anton Venter – Community Spotlight

Kudos to our October Community Star of the month!

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Dynamics 365 Community Newsletter - September 2024

Check out the latest community news

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,552 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,552 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Product updates

Dynamics 365 release plans