Sean Bailey (SeanB897)
Nationwide Building Society

Nationwide Building Society
SeanB897 Member since 2017 24 posts
Nationwide Building Society
Posted: April 15, 2019
Last activity: April 16, 2019
Posted: 15 Apr 2019 7:51 EDT
Last activity: 16 Apr 2019 9:29 EDT

Compare two American dates Robotics


I would like to compare two American dates and identify whether one is greater than the other. I am encountering two issues:

The date the automation gets from a SharePoint site is in American format MM/dd/yyyy hh:mm

I would like to convert the string to yyyy/MM/dd hh:mm so I am able to compare the two dates to identify which is the greatest date. The automation I have developed is below:

The first issue I have is - the Proxy does not seem to put the date into the format of yyyy/MM/dd and keeps it as yyyy/dd/mm for instance 03/08/2019 I wish to convert to 20190308 but it is converting to yyyy/dd/MM.

The second issue I am having is it does not recognise 06/14/2018 as a date therefore when passed into the datetime variable it causes an error suggesting that this is a date. I am based in U.K so my locale is English.

Any help on this would be much appreciated.

Robotic Process Automation
Moderation Team has archived post, This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.