I am testing TDP 4.2.1, and I really thought I had submitted this previously, but I am seeing my string variable surrounded by single quotes. I created variable “today” as To_char(Current_date(), ‘MMMM DD, YYYY’). I then put it in the file name, email body, and email subject. When the script runs, it looks like this:
file: Test Workorder Shortage ‘August 31, 2017’.xlsx
Email subject: Shortage for ‘August 31, 2017’
Email body: Report for ‘August 31, 2017’
Why the single quotes? I am setting off the variable with # surrounding. Is there something else I should be doing?