ETL and Data Integration tools - Modern ETL software for everyone

Support,

You were very good in helping with the mask in file names using functions in
the system. See below:

\\Rptsvra\pir\EMU\FTP\GIS
downloads\CW-RepComp-{LeftString(GETSYSTEMVARIABLE('SYSTEM_DATE'),8)}.csv

Will

\\Rptsvra\pir\EMU\FTP\GIS
downloads\CW-RepComp-{LeftString(GETSYSTEMVARIABLE('SYSTEM_DATE')-1,8)}.csv

Give me the day before the current date?

Thanks!
Ian

Hi

It will give you an error becase GETSYSTEMVARIABLE('SYSTEM_DATE') returs a string

Use DecDateS

Mike

DecDateS

DecDateS(Date,Format,ChangeType,Decrement):String.

ChangeType: YEAR,MONTH,WEEK,DAY,HOUR,MINUTE,SECOND

Use DecDateS to Decrease ChangeType part of a date value by an Decrement.

DecDateS ('01012003','DDMMYYYY', 'YEAR',1)

\\Rptsvra\pir\EMU\FTP\GIS downloads\CW-RepComp-{DecDateS (LeftString(GETSYSTEMVARIABLE('SYSTEM_DATE'),8),'YYYYMMDD', 'DAY',1)}.csv

So this should give me:

Today: 20070525
Output: 20070524
Does this seem correct?

Charles