Working with Filenames and Directories

Consider the following scenarios:

• Data is exported from the database daily and needs to be saved in a file with the current date included in the file name.
• Yesterday’s data needs to be loaded from a folder that includes the date as part of its name.

We can use functions in filenames to do it as follows

GETSYSTEMVARIABLE('SYSTEM_DATE')

will return current date in ‘YYYYMMDDHHNNSS’ format

If we want only part of the date we can use LeftString(String,Count):String for example

LeftString(GETSYSTEMVARIABLE('SYSTEM_DATE'),8)

will return only date part.

Now more complicated example for loading yesterday’s data;

LeftString(DecDateS(GETSYSTEMVARIABLE('SYSTEM_DATE'),'YYYYMMDDHHNNSS', 'DAY',1),8)

Another example:

C:\Data{GetSystemDate('YYYYMMDD')}.csv

For complete reference of available functions consult Supported Functions List