
Announcements
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
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.