title: Blue Prism How to calculate text date times?
body: <p>is it possible to calculate text dates? Or to remove just the rest of my text?</p>
  
  <p>I need to calculate days of leave. I have two data items and I must substract one from another. For example 11/3/2017 12:00:00 AM - 3/31/2017 12:00:00 AM. How can I do this? So far I've tried Replace function. I wanted to use Mid, Trim and Left but the characters in my date items are going to change. so sometimes I will have 9 characters (11/3/2017) and sometimes 8 (1/3/2017).</p>
  
  <p>Which function could I use ?
  this format is month/day/year and mine is day/month/year</p>