ETL and Data Integration tools - Modern ETL software for everyone

Hi

I’m trying to create the date format CampaignResponses_20100111T095000.xls in a file name.

The way I am doing this is CampaignResponses_{GetSystemDate('YYYYMMDD')}T{GetSystemDate('HHNNSS')}.xls"

It throws up an error – can you not use more than 1 GetSystemDate in a file name?

Kind regards,
Andrew

Try this one

CampaignResponses_{GetSystemDate('YYYYMMDD')+'T'+GetSystemDate('HHNNSS')}.xls"

Mike

Thank you for the prompt reply

It works now

Andrew