![johndanter](/community/data/avatars/m/11/11172.jpg?1590187253)
johndanter
Legendary Poster
Hi List,
I have a weird one I can't think how to solve.
A User drops a CSV file, EBI software picks this data up and maps the data into an F47 table. I've then written a UBE to read the inbound data and check various things before entry into E1.
One of the things I've been asked to check is the Effective Date (F41061.CBEFTJ) is in the correct format. YYYMMDD.
So how do I do that? As EBI will map a value into this into my F47 F41061 equivalent table and then my code will have to check it somehow..............but how????
How do you check date is 'valid' in E1?
Could I maybe split the parts out using B0000078 and then ask is the days between 1 - 31 and months 1 - 12? That's all I can think of.
Or...I was thinking of adding a new string column to my F47 table (it's F57 really) and then validate it from there. But what BSFN checks YYYYMMDD
EDIT: This works actually
Convert String to Date Using Format Mask B74I0010 YYYYMMDD
Converted Date < 31/01/74
StringToConvert > 19740131
FormatMask > EOA
Thanks
John
I have a weird one I can't think how to solve.
A User drops a CSV file, EBI software picks this data up and maps the data into an F47 table. I've then written a UBE to read the inbound data and check various things before entry into E1.
One of the things I've been asked to check is the Effective Date (F41061.CBEFTJ) is in the correct format. YYYMMDD.
So how do I do that? As EBI will map a value into this into my F47 F41061 equivalent table and then my code will have to check it somehow..............but how????
How do you check date is 'valid' in E1?
Could I maybe split the parts out using B0000078 and then ask is the days between 1 - 31 and months 1 - 12? That's all I can think of.
Or...I was thinking of adding a new string column to my F47 table (it's F57 really) and then validate it from there. But what BSFN checks YYYYMMDD
EDIT: This works actually
Convert String to Date Using Format Mask B74I0010 YYYYMMDD
Converted Date < 31/01/74
StringToConvert > 19740131
FormatMask > EOA
Thanks
John
Last edited: