Joined: 06 Jun 2008 Posts: 8696 Location: Dubuque, Iowa, USA
The same people who respond on this board also respond on the other board, so posting here will not get you better answers than you've already gotten. The lack of responses so far may indicate that nobody knows how to do what you want, or that what you want cannot be done, or nobody with the appropriate knowledge has read your posts.
Furthermore, since Syncsort is an independent software vendor product, you are VASTLY more likely to get what you want by contacting Syncsort support and working with them. Vendors know their products, generally, much better than people responding on a forum. And if your site has a license for Syncsort then you are entitled to get support from them.
I was trying to figure this out but I am having no luck. Why is it showing today's date as THURSDAY? Where in DATE1 is there a day of the week position? I keep looking at this and DATE1 should be YYYYMMDD. Am I missing something?
I just noticed that I have applied a wrong offset for the day of week.
Unnoticed problem: the date is being fully re-calculated for EACH record of the report, plus INSERTED only when header line position is reached. In case of HEADER1 - it is used once per report...
Joined: 15 Aug 2015 Posts: 1231 Location: Bamberg, Germany
sergeyken wrote:
Unnoticed problem: the date is being fully re-calculated for EACH record of the report, plus INSERTED only when header line position is reached. In case of HEADER1 - it is used once per report...
I can rest you assured that I was aware of that situation.
Makes use of SYMBOLS and calculates the requested Date/Time only once.
Code:
********************************* TOP OF DATA **********************************
BACKORDERED PARTS WITH NO SDI 21:01 Wednesday, May 27, 2020
EMER
PART NUMBER B/O DATE ORDERS LINES
------------------ ---------- ------ -----
Data
Data
Data
******************************** BOTTOM OF DATA ********************************