As background, I am pulling a date from a report online using ‘Copy Selected Text’. I am then converting the date using Date Parse Extract (see below) and then adding days to that (e.g., 7 days) and then taking that new date and update the report field.
Here is the issue: If the date is March 1, 2019, it is displayed on the site as 3/1/19 which works fine for the formula. The problem arises where I have different date formats which will make the date parse invalid. Here are all 4 possible date formats (with examples):
I need to be able to have the bot choose the correct format to be able to convert and then add days, otherwise the formula will not recognize and return an invalid format error.
Any suggestions on how to make this formula dynamic or other solutions?