Question function yesterday for manipulation of files with name aleatory

function yesterday for manipulation of files with name aleatory and patron standard please help

Example:

today is 20180625


and i am need the file of yesterday

RPT_ACCESS_20180624.xlsx


thank you!

Hello,

The solution may depend on the context : do you want to define this file name in a mapping ? in a process ? Is it for a single file or a batch of files ?

Here is a quick example which can be used in a File Name property of a metadata or template :
Please provide more information about your context, if you need a more specific example

Hello!
How do I set a year ago?

Tks

Hi,
As said above : The solution may depend on the context : do you want to define this file name in a mapping ? in a process ? Is it for a single file or a batch of files ?

Hi!
I want to use as a parameter in the filter of a mapping

I'm not sure I understand what you need to do. Having a timestamped file name as a filter in the source of a mapping is not clear to me.
Please provide more details

Hi!
For example.
I want to set in a variable the date a year ago, 2018/01/14.
Using the expression "% x {md: formatDate ('yyyyMMdd')} x%"

I found the article below:
stambia.org/component/content/article?id...es-with-dynamic-name

But it does not show me how to set a year ago.

I could put:
% x {md: formatDate ('yyyyMMdd', "-365")} x%,
but it would have problem when the year is leap year.

Hi,
You are right : doing -365 days is not exact with leap years.
The alternate solution to substract 1 digit from the Year is also false when executed on the 29th of February in a leap year.
What would you expect as a valid result in this case, by the way ?
29/02/2020 minus one year = ?