timestamp a file with a date range

(0) Share

Report

Posted on by taxgeek2004

Hi everyone

Im a relatively new user of this automation, so apologies if any of this is silly stuff!

Anyway, I've modifed a template to transfer a file to sharepoint but I'd like to stamp it with the date from and date to to make sure I all dates are covered off when they come to be processed. Using getpasttime will work with interval of 1, and another one of 8 will get the from and to date, but it has a lot of other useless info like time etc that I don't need.

I failed miserably with the compose function to try and change this as i think it sees the output as a string and so my googling ability to resolve gets stuck!

Could someone confirm what the compose would be to make the file have "file name + -8 days to -1 day" relative to todays date?

Thanks

Cass

All responses (1)

Answers (1)

Verified answer

v-litu-msft on at

Like (0)

Report
Re: timestamp a file with a date range

Hi @taxgeek2004,

You could use the concat() function to connect "fileName" and date range.

For example:

concat('fileName+',addDays(utcNow(),-8,'yyyy-MM-dd'),'to',addDays(utcNow(),-1,'yyyy-MM-dd'))

Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.