How do I convert a Date field and a Time field so that I can sort on them
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?