You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Include Dynamic dates in File Name for Scheduled Custom Report

edited Jul 7, 2024 1:37PM in Applications Security 1 comment

Summary: We are scheduling a weekly custom report to run each Tues night for the previous weeks' data (ie. Jun-17 thru Jun-25) Is it possible to include the date parameters in the file name as GL_Details_MM-DD-YYYY_MM-DD-YYYY or GL_Details_06-17-24_06-25-17.csv

Job is scheduled to run each Tues Night and has a trigger back to Data Model. Date Parameter on DM = Posted Date. Query has been designed to fetch the posted date and retrieve data from Posted date - 8 days.


Content (please ensure you mask any confidential information):


Version (include the version you are using, if applicable):

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!