Close popover
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

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