Weekday in filename

Thu, 22 Mar 2012 08:13:27 GMT

Hi all!

I'm working on a script, that saves a table in a certain directory. Now I want the file to be named including todays weekday.

For example: File_Monday; File_Tuesday etc...

The store command ends like this:

INTO $(ShareDirectory)File_Weekday.csv (ansi, txt, delimiter is ';', embedded labels);

Can anyone help me, what to fill in, to get the right day?

Thanks in advance

Peter

SunilChauhan — Thu, 22 Mar 2012 08:28:01 GMT

create a variable

var= weekday(fieldname)

then use

$(ShareDirectory)File_$(var).csv

hope this helps

topic Weekday in filename in Water Cooler