# toad variables

**URL:** <https://forums.toadworld.com/t/toad-variables/39633>\
**Category:** Toad for Oracle & DevOps Toolkit\
**Created:** [June 27, 2017, 9:45am UTC](https://forums.toadworld.com/t/toad-variables/39633 "2017-06-27T09:45:18Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![jgar2](https://avatars.discourse-cdn.com/v4/letter/j/c4cdca/32.png) [@jgar2](https://forums.toadworld.com/u/jgar2)\
**Post date:** [June 27, 2017, 9:45am UTC](https://forums.toadworld.com/t/toad-variables/39633/1 "2017-06-27T09:45:18Z")

</div>

How do you dynamically get a value into a toad variable.

tying to get somthing like this

c:\folder1\sub\_folder\filename’|| to\_char(sysdate,‘MM’) || ‘_’ || to\_char(sysdate,‘DD’) || '_’ || to\_char(sysdate,‘YYYY’) ||’.csv’ fqfn from dual; result: “c:\folder1\sub\_folder\filename\_06\_27\_2017.csv”

I want to use it in email automation.

---

<div class="post-metadata">

**Author:** ![damir.vadas\_250](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/damir.vadas_250/32/37_2.png) [@damir.vadas\_250](https://forums.toadworld.com/u/damir.vadas_250)\
**Post date:** [June 27, 2017, 11:33am UTC](https://forums.toadworld.com/t/toad-variables/39633/2 "2017-06-27T11:33:08Z")

</div>

Try mine solution:  
[damir-vadas.blogspot.co.at/…/toads-automation-designer-and-sqlplus.html](http://damir-vadas.blogspot.co.at/2016/10/toads-automation-designer-and-sqlplus.html)
