Use a dynamic formula for task configurations
This section is to show how to use dynamic formulas in RoboIntern. In particular, the creation of a new version of a file for the latest date is demoed.
Formulas work in a very similar way as in Excel.
Supported functions are NOW, TODAY, WEEKDAY, WORKDAY, DAY, MONTH, YEAR, EOMONTH, DATE and TEXT.
| 1. Enter the below formula to get a file name that has the previous date in format YYYYMMDD in it: ="C:\myFile_" & TEXT(TODAY()-1,"YYYYMMDD") & ".txt" Hoover the mouse over the text field to get the current formula result |
 |
| 2. Enter the below formula to get a file name that has the latest date in format YYYYMMDD in it: ="C:\myFile_" & TEXT(TODAY(),"YYYYMMDD") & ".txt" |
 |
And that's it!
For more advanced tasks please see other sections of the how-to guide.
Happy automation!