#BLUE PRISM STOCK DISCUSSION UPDATE#
#BLUE PRISM STOCK DISCUSSION PASSWORD#
#BLUE PRISM STOCK DISCUSSION WINDOWS#

Subject: Blue Prism Date formatting inconsistencies - save to Excel vs. In order to make life a little easier for us developers, and provide a consistent method in data presentation to our business, an object was created that gets the date we need, most often the current date, and formats it to our date standard. In our shop, from early on we had challenges with date formatting in reports and documents.

As such, I would suggest XL to be the culprit on any form of formatting deviations and delimiter creativity, as it was at least in my test opening the CSV in XL. I get the correct formatting as well as the correct delimiter. Upon opening the CSV in NotePad++ however, the results are exactly as I would expect them to be.

Using yy rather than yyyy as the year format in your CSV data, does indeed make XL seriously mix up the format, providing this: yy/MM/20dd - in short: this is a royal mess!

#BLUE PRISM STOCK DISCUSSION WINDOWS#

So I assume the format is taken from XL options, likely combined with Windows Regional and Date settings. Well, not really mixed as it actually looks like a genuine mess in XL! The format as well as the delimiter are set by XL without any regard to whatever I decided to set it to be in my process (Date/Text). When opening this CSV in XL, it gives mixed results. When embarking on a similar experiment, I only had my process create dates in Date format and in Text format in a CSV. Using example date (NZ/UK format 10 January 2023)ĭate Format dd/mm/yyyy Text Format dd/mm/yyyy Text Format dd/mm/yy

'Save As CSV' uses a custom object but in essence uses: wb.SaveAs(filename,6):.

#BLUE PRISM STOCK DISCUSSION UPDATE#

Please join us on Augto hear the Blue Prism Product Vision & Roadmap Update from senior products leaders at SS&C Blue Prism. Text where the year is in yy format (not yyyy) Register now for Blue Prism Product Vision & Roadmap Update Webinar.To demonstrate, create a collection with 3 data elements: date format saved to Excel retains dd/mm but text date format changes to mm/dd whereas text date format saved to Excel csv is retained but date format is converted.

My camerade wanted a project that sends out reminders from his FB account.Blue Prism Save to Excel produces a different results depending on: The key features, the differences, and everything else about UI Path, Automation Anywhere, and Blue Prism have been discussed below. They can come up with an idea for automation. Then you spy the very left window in his channel, compare the read date with the previous and if it is higher then you send yourself an alert :)Īre you in for more serious things then maybe ask some of your friends that run a business. Or you would like to know whether some youtuber has released a new video. Without you missing the rewards in case you still want to play. It is easy to forget this sort of stuff while RPA robot could do it weekly for you. Maybe you have a online game you just need to login to, click somewhere to collect some rewards and logout.

#BLUE PRISM STOCK DISCUSSION PASSWORD#

Obviously take security into account whether you can have those password in BP or anywhere in PC (instead of piece of paper ) ). Have BP robot create password in VBO Credentials, login to the app, change password if needed/prompted, write down the password in credentials in BP. Maybe you have an app you dont login too much and you dont remember password. There is actually a plenty of ideas in reach for everyday PC user if you dont have a chance to automate a task at work.

Blue prism stock discussion