Add the date to OMS file name

Moderators: statman, Analyst Techy, andris, Fierce, GerineL, Smash

mwulfe
Posts: 7
Joined: Mon Feb 13, 2012 3:24 pm

Add the date to OMS file name

Postby mwulfe » Mon Oct 01, 2012 10:23 pm

I want to include today's date in the output filename using OMS, something like this:

* OMS.
OMS
/SELECT TABLES
/IF COMMANDS=['CTables'] SUBTYPES=['Custom Table']
/DESTINATION FORMAT=XLS
OUTFILE='C:\MyFiles\Chapters\' +
Date() + 'chapter01.xls'.[/color]

Of course the above code does not work. What is the best syntax to do this?

Thanks,
Martin

Who is online

Users browsing this forum: No registered users and 1 guest

cron