title: Format Datetime in Business Objects
body: <p>So I know I can use =FormatDate(MyDate ,"mm/dd/yy") to turn a date into a string.  I am then trying to add on a time:</p>
  
  <pre><code>=FormatDate(AdminDate ,"mm/dd/yy") + MyTime
  </code></pre>
  
  <p>Which works, however, I need to format this back to a datetime field (as I need to compare against a preexisting datetime field).  I try using Todate(), but the documentation is very light, and provides very little on what is acceptable in  the formatting of the date area, and nothing in the way of time!</p>
  
  <p>I have attempted:</p>
  
  <pre><code>=ToDate(FormatDate(MyDate ,"mm/dd/yy HH:mm:ss") + MyTime ,"mm/dd/yy HH:mm:ss")
  </code></pre>
  
  <p>but this will only work when there is no time (and it just nulls out the time)  and any row with a time will return a #ERROR</p>
  
  <p>Anyone have an insight on formatting datetimes?</p>
  
  <p>Thanks</p>