DSXchange

Hi, I forgot to tell something, the date to convert , will not be the current date, but an another parameter (let's say paramB). this parameter is a string formated DD/MM/YYYY. So, in the above code, I'll need to replace @date by a conversion from my parameter paramB. CONVERT('-','',OCONV(@DATE-7,'D...

Hello,
thanks you for your answer.
Please, accept my apologies for my poor english as it is not my natural language.

you've been a great help, thanks a lot.

Hi, I got a job (named jobA) that have tu put final data in a sequential file. The name of the file must fit that pattern myFile_DATE1_DATE2.csv DATE1 represents the today date minus 7 days. DATE2 represents the today date. DATE1 and DATE2 must be formated : YYYYMMDD I may have found a solution : my...