Hi Lisa,
You can use the Timestamp Utility service:
https://www.ibm.com/support/knowledgecenter/en/SS3JSW_6.0.0/integrating/integrating/integrator/Timestamp_Utility_svc.htmlFor example use the Timestamp Current Time function to get the current month e.g. set format to yyyyMM, then use the XPATH concat() function to append 01 to pass that in as baseTime to the Timestamp subtract function to get the date of the last day of the previous month (baseTimeFormat and format = yyyyMMdd, offsetTime = 1 and scale = day).
You can then use the concat function again on ASSIGN to append that to the filename (maybe combined with using the substring functions to insert it in the appropriate position e.g. before any extension).
------------------------------
RICHARD CROSS
------------------------------
Original Message:
Sent: 10-08-2018 15:34
From: Lisa Bush
Subject: calculate date for consumer file name
We have a need to calculate a date for the consumer file based on the run date of the channel that is picking up the file. For example, if the file is picked up October 3, the date as part of the file name needs to be the last day of the previous month (i.e. September 30). I understand this would have to be done with a BP which we do not have for this. Any help would be appreciated on how to write a BP process to accomplish our goal.
------------------------------
Lisa Bush
------------------------------
#filetransfer
#DataExchange