Possible to Override Date Format in EDI Output?
Use Case - We are running EDI in US and EU. US user profiles have MDY date format with "/" separator. The EDI output file generates dates as MM/DD/YY and our translator is set to handle this format. EU user profiles have DMY format with "-" separator. The EDI output file generates dates as DD-MM-YY. Unfortunately this is throwing an error in our translator. We need all EDI output dates to be standardized regardless of user profile set up.
1. Is there anyway to override the user's date format at a report level?
OR
2. EDI uses Database Output functionality in RDA. I tried adding an Edit Override to a date field in the Database Output. I set the Display Rule to MASK ASOSR, but the output remained MM/DD/YY (my user default setting).