Noob here.
I want to schedule a report to deliver a csv at a daily frequency to my FTP host. Doing this by setting up the report, then Send > Advanced > [fill in the details] and saving.
My problem is that I want to set a Custom name for the report, which should include the report date range, updated daily. There is a small check box which appends this date range, but the format of date is long text: "Sun. 1 Sep. 2019 - Tue. 3 Sep. 2019" which is causing a forbidden/unrecognized issue at the FTP end. I don't have FTP admin or security access to change this.
Can anyone inform me if there is a way to change this format into "20190901" or "09/01/2019" or any other viable substitute.
I have made some attempts to follow this: Format the date but either the syntax has something missing or the "Custom name" field is not accepting.
Appreciate any leads, thanks.