title: Convert Date from Text to Date Time for WebI 4.2
body: <p>I am trying to calculate the duration between StartTime and CurrentDate. However, the StartTime data comes in Text Form as below. I tried converting it using =ToDate([StartDate];&quot;MMddyyyy&quot;) but got #ERROR instead.</p>
  <p><a href="https://i.stack.imgur.com/DAWee.png" rel="nofollow noreferrer">StartTime data</a></p>