Skip to main content

Notifications

Microsoft Dynamics GP (Archived)

change check print date formate

(0) ShareShare
ReportReport
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

*This post is locked for comments

  • 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

News and Announcements

Announcing Category Subscriptions!

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Verified Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,359 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,370 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans