on exporting a datagrid via excel onto a folder in my computer, is there a way to add the date to the excel name.

i have the "get system folder" and "export to excel" which includes the file name i choose, but eveytime i run this extraction, i want the date (ei. march15 or 031510) to be included in the file name as well. whats the best way to create a variable that captures the days date?

Here is an example:

Get current Date-Time and store in variable [CurrentDateTime]
Format Date-Time [CurrentDateTime] by specifications yyyymmdd, place resulting text in [aDateNow].
Export to Excel using data grid [DataGrid1] to file c:\[aDateNow].xls (Overwrite: Yes)

Tijn

thanks...

i did everything as above, the Export to Excel i am using has filename as
[desktop]BofA.xls which is the original version and works. this saves to my desktop no problem.

BUT when I use [desktop]BofA[Date].xls it gives me an Error "data export not successful" the[Date] is a variable because i created a messagebox that displays [Date] and todays date displays.

I tried every mix possible and everything works except using [Date] as part of the file name to export to desktop,

is there a problem using a system folder and the [date] variable?

Perhaps you can attach your script to your post.
I think you have not formatted your date correctly.
Note that a slash from the date variable is most likely resulting in a bad path that is not allowed by your OS.

Tijn

Thanks for the help..

here is the script

You had a date format specification dd/mm/yy.
The slash is not allowed in a Windows file path.

I changed it to a specification ddmmyyyy

See the attached updated script.
Tijn