AnsweredAssumed Answered

How do I convert a Date field and a Time field so that I can sort on them

Question asked by obabilon on Aug 20, 2013
Latest reply on Aug 23, 2013 by obabilon

Title

How do I convert a Date field and a Time field so that I can sort on them

Post

      

     I've tried:
     GetAsDate ( TheDate ) where my text looks like this: 8/1/13 and then yields this: 3/19/0023
     GetAsTime ( TheTime ) where my text looks like this: 4:15 PM and then yields this: 0:06:55
      
     As you can see it's not yielding the correct results. I would like to have a date that I can sort each record so it sorts for the whole year and the time sorts so that AM comes before PM. Can you help me?
      

Outcomes