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
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)...
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
290,552
Super User 2024 Season 2
#2
Martin Dráb
228,552
Most Valuable Professional
#3
nmaenpaa
101,148
Share
Report
All responses (
Answers (