7 Replies Latest reply on Aug 23, 2013 7:02 AM by obabilon

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

    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?