We have scenario where users enter the date in the email body (free text).
Ex: Start Date : 08\24\2021
Start Date : August 24, 2021
Start date : 24\08\2021
Start date : July 24, 2021 @ 3:12 PM
I am able to get the entire text followed by Start Date: XXXXXXXXX, Using RegEx
I have a problem, I need to get the day of the last Friday of the month, FROM the current date. I tried everything but I can't find the solution, has someone already tried something similar to guide me?
It would be very helpful.
Thanks a lot
I am trying to read date from a particular cell(Date format) in Excel(using OLEDB). Whenever the date is read, in the output the date changes to its previous day.
Eg:- If the date in the cell is 17/02/2021 after reading in Blue Prism the output shows 16/02/2021.
I’m trying to identify the required regex to isolate a date from a text string. The string is in the following format: January 12, 2020
I need to be able to identify any date of any year.
Can anyone help me with this?
Thanks in advance
For FormatDate() as Per The help Document (HelpDocument mean When You open the Calculation Stage Click Question MArk it will redirect to Help Document > Studio>StudioUsage>Calculations and Decisions )it is saying
FormatDate("02-11-2016 09:23:43", "t") will return "09:23" As...
I need to select a file whereby the file name will reference last Monday and last Sunday in the filename.
So For example today is 03/08/2018. The file my process would need to select would include the dates 23/07/2018 and 30/07/2018.
I have tried to use calendar objects and such but...
I have a date and i would be adding 7 days to the existing date if the resultant date is a Sunday or Saturday or any holiday it should postpone the date to Monday or a consecutive date after Sunday or holiday.
Thanks and Regards,