Rename File with Modified Date - 1 Day Variable

[Anonymous]

Looking to see how to rename file to 1 day before last modified date.
For example, if Last Modified = Jan 01, 2022,
File name should be 2021-12-31
and not 2022-01-01

Is there an expression I can use on the Datetime Format field?  Or how would I go about resolving this?

Note the original folder will have lots of files from many different dates and we are moving the file out of the original folder once renamed.

[MichaelAnnis · Accepted solution]

I don’t think you can do it in here. But you can do it. 

you are probably in a for each loop, so i am going to assume the current file being renamed is %CurrentItem%. Which means the Last Modified Date is %CurrentItem.LastModified%

Add datetime to %CurrentItem.LastModified%
    -1 day to %DateFile%
Convert DateTime to Text %DateFile% custom format yyyy-MM-dd to %DateFile_yyyymmdd_Dash%
Rename %CurrentItem% to %CurrentItem.NameWithoutExtension%_%DateFile_yyyymmdd_Dash%

good luck!

[VJR · Accepted solution]

- Get the File's last modified datetime

- Then use -1 in the below action

This will give you a variable with the new date time.

- Use that variable in the "Rename file" action

Do this for each file in the loop.

[Anonymous]

Thank you both! Used a combo of the 2 and it worked perfectly!