Sorting a concatenate Date and time field

[poul0035]

I have a query that combines a date field and a time field together. When I try to sort that it seems to treat it as a text so that either Jan (1) will be at the top or Sep (9) will be at the top. Is there a way to sort this concatenate field based on earliest or latest?

 

[vbaInet]

I have a query that combines a date field and a time field together. When I try to sort that it seems to treat it as a text so that either Jan (1) will be at the top or Sep (9) will be at the top. Is there a way to sort this concatenate field based on earliest or latest?

Cast your string to a date using CDate()

 

[poul0035]

That did it. Thanks.

 

[vbaInet]

You're welcome. I would also suggest you trim it as well before casting, like this:

CDate(Trim("concatenatedString"))