# Copied file suffix not working properly in TDA 3.0 automation **URL:** \ **Category:** Toad Data Point & Toad Intelligence Central\ **Created:** [October 17, 2011, 11:00am UTC](https://forums.toadworld.com/t/copied-file-suffix-not-working-properly-in-tda-3-0-automation/6922 "2011-10-17T11:00:06Z")\ **Posts on this page:** 4\ **Page:** 1
**Author:** ![Texrat](https://avatars.discourse-cdn.com/v4/letter/t/b3f665/32.png) [@Texrat](https://forums.toadworld.com/u/Texrat)\ **Post date:** [October 17, 2011, 11:00am UTC](https://forums.toadworld.com/t/copied-file-suffix-not-working-properly-in-tda-3-0-automation/6922/1 "2011-10-17T11:00:06Z")
I just upgraded to TDA 3.0 from 2.7 and having some trouble migrating automations. I have a copy file step that does create a new file but the suffix does not render properly. I am using #yyyy-MM-dd\_HH-mm#, which worked in 2.7, but results in the number 0 in 3.0. I tested the built-in Date and Time suffix, but it forces seconds and I don’t want them shown. If I manually strip out the -ss for seconds, Toad throws up an error. Note that this automation worked fine in 2.7. Anyway idea what could be going on? EDIT: also, I would like to change the year/month order in the format string. The built-in string forces the year to show first. Message was edited by: Texrat ---
**Author:** ![IgorM](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/igorm/32/116_2.png) [@IgorM](https://forums.toadworld.com/u/IgorM)\ **Post date:** [October 19, 2011, 3:05pm UTC](https://forums.toadworld.com/t/copied-file-suffix-not-working-properly-in-tda-3-0-automation/6922/2 "2011-10-19T15:05:04Z")
You’re right. There is definitely a problem. I created high priority CR91746 to track this issue. Thanks for reporting, Igor. ---
**Author:** ![Debbie\_Peabody](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/debbie_peabody/32/18_2.png) [@Debbie\_Peabody](https://forums.toadworld.com/u/Debbie_Peabody)\ **Post date:** [October 19, 2011, 9:25pm UTC](https://forums.toadworld.com/t/copied-file-suffix-not-working-properly-in-tda-3-0-automation/6922/3 "2011-10-19T21:25:03Z")
select to\_char(sysdate, ‘MON DD YYYY HH24 MI’) from dual I did find an issue with using any normal format separator characters such as /-. The Copy file function just doesn’t like any of those. But I think you can find something that will work for you. Debbie As a work around I would use a Select statement to format a variable the way I want it. Then append the variable to the file name. I have attached sample script. I use an Oracle connection and this SQL. You would need to adapt to your database type and how you want the format. ![DateTimeSuffix.png](https://global.discourse-cdn.com/quest/original/2X/8/815667ac436f6f5e5272352a775f3b35ae6c7b0c.png) ---
**Author:** ![Debbie\_Peabody](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/debbie_peabody/32/18_2.png) [@Debbie\_Peabody](https://forums.toadworld.com/u/Debbie_Peabody)\ **Post date:** [October 19, 2011, 9:25pm UTC](https://forums.toadworld.com/t/copied-file-suffix-not-working-properly-in-tda-3-0-automation/6922/4 "2011-10-19T21:25:03Z")
select to\_char(sysdate, ‘MON DD YYYY HH24 MI’) from dual I did find an issue with using any normal format separator characters such as /-. The Copy file function just doesn’t like any of those. But I think you can find something that will work for you. Debbie As a work around I would use a Select statement to format a variable the way I want it. Then append the variable to the file name. I have attached sample script. I use an Oracle connection and this SQL. You would need to adapt to your database type and how you want the format. [Script\_1.tas](https://global.discourse-cdn.com/quest/original/2X/5/54997712cdc1bcbff5650016483f4c5f081de3ac.tas) (6.33 KB)