I want to pick those files as well whose last modified date is +10 second after my current copy activity starts

Question

I am picking files from a folder to convert it into parquet . But it is missing some files during filtration ,hence those files not getting converted into parquet.

So I am trying to add 10 second as buffer using addSeconds('2018-03-15T00:00:00Z', 10) function . At End time of filtered by last modified , we were using using UTCNOW(). But I am not able to use this utcnow() within addSeconds() funtion .

I used it in this format :-

@addSeconds('utcnow()', 50)

Getting below error:-

In function 'addSeconds', the value provided for date time string 'utcnow()' was not valid. The datetime string must match ISO 8601 format.

So I am looking for an alternate to this.

Answer 1

Hey

Try the below expression :

@addSeconds(utcnow(),50 )