# Automation file export name date time suffix

**URL:** <https://forums.toadworld.com/t/automation-file-export-name-date-time-suffix/35267>\
**Category:** Toad for IBM DB2\
**Created:** [March 11, 2016, 2:27pm UTC](https://forums.toadworld.com/t/automation-file-export-name-date-time-suffix/35267 "2016-03-11T14:27:40Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![dkirby](https://avatars.discourse-cdn.com/v4/letter/d/ecc23a/32.png) [@dkirby](https://forums.toadworld.com/u/dkirby)\
**Post date:** [March 11, 2016, 2:27pm UTC](https://forums.toadworld.com/t/automation-file-export-name-date-time-suffix/35267/1 "2016-03-11T14:27:40Z")

</div>

trying to format the suffix on a file. i need it to be a date timestamp in the following format. YYYYMMDDhhmm There is somthing about the format the system does not like. Any ideas? Version 6.1

---

<div class="post-metadata">

**Author:** ![rkenney\_25521](https://avatars.discourse-cdn.com/v4/letter/r/e68b1a/32.png) [@rkenney\_25521](https://forums.toadworld.com/u/rkenney_25521)\
**Post date:** [March 12, 2016, 9:18am UTC](https://forums.toadworld.com/t/automation-file-export-name-date-time-suffix/35267/2 "2016-03-12T09:18:00Z")

</div>

Without knowing what error you are encountering it is a bit difficult to respond with something that will be helpful. I am presuming you are on Unix and setting a variable (var=$(date +%Y%m%d%H%M)) and then specifying a file name as file\_name\_${var}. What issue are you encountering?