ETL and Data Integration tools - Modern ETL software for everyone

I have a file that is being downloaded in this format - HUUU10X06232008.csv with the date in the file name MMDDYYYY.
I need to be able to pull the file for the current day using a filter in the import node.
Is there an easy command like FormatDate that can be used?

Currently I am pulling from system date YYYYMMDD.

Thanks in advance for your help!!

Use

c:\whateverpath\HUUU10X{FormatDateTime('MMDDYYYY',now)}.csv

FormatDateTime formats the TDateTime value given by DateTime using the format given by Format. See the table below for information about the supported format strings.

From documentation

Note:
Only one {} pair is allowed.

GETSYSTEMVARIABLE('SYSTEM_DATE') will return current date in ‘YYYYMMDDHHNNSS’ format

If we want only part of 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)

Note:

For complete reference of available functions consult chapter 16.