Current Date in File Name while Storing the QVD or CSV

Sun, 17 Mar 2013 06:26:48 GMT

Hi,

I need to append the current date (Today's Date) in the file name while storing the QVD or CSV.

Like This,

Test:

LOAD

* INLINE [
EmpCode, EmpName
100, ABC
201, EFG
];

STORE EmpCode,EmpName from Test into FileName.csv(txt)

Here instead of filename i need to store like Filename+today() .csv

Filename17032013.csv

Thanks,

Selva

Re: Current Date in File Name while Storing the QVD or CSV

Sun, 17 Mar 2013 06:53:44 GMT

I got it,

LET vDate= Date(Today(), 'DD-MM-YYY');

STORE EmpCode,EmpName from Test into FileName_$(vDate).csv(txt)

Output: FileName_17-03-2013

Thanks,

Selva