Announcements
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
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
For the Day: (C) StrDay
For the year: (C) StrYear
You can now create the concatenated version of the date as needed, using whatever format you need: (C) ConcatDate
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.
Yes, the date format is based on the computer region settings (Short Date)...
André Arnaud de Cal... 291,359 Super User 2024 Season 2
Martin Dráb 230,370 Most Valuable Professional
nmaenpaa 101,156