I am setting up an EFT for a Canadian bank that for the date, uses "MMDDYY".
Setting up the Data Exchange Def shouldnt be this complicated.
Using the current files and setup for RB, when the when it creates the mappings and such, makes the FILE CREATION DATE and converts it to a Julian date format.
There should be a place to either check if you want that date... or to keep is a standard date.
In the date exchange column definitions... should have a way to set the date back or something like that.
I have tried in the Data Format column '<Day,2><Month,2><Year>' but it balks at that.
I am trying to keep from having to use code... as this is "supposed to work from a user perspective with no changes to code as its all setup", or so I have been told.
Is there something I am missing in the creation of the Data Exchange Definition and setup?
All I want is my "2019010" Julian date to read what it originally was "01/09/2019"... and then converted to MMDDYY.
Thanks In Advance.