Query Loop with metabox date field

Hi folks, i’m trying to show some data, sorted by the date field in a metabox custom post type.

I have a date field in the query loop with the ID/meta key “workshop-date”.

I have gone into the query loop and selected “order by” and have chosen the “meta value” option. In the order meta key box underneath that I have put in the ID “workshop-date” and selected “ascending” for the order.

Unfortunately, it’s not sorting by date in ascending order.

To add to the confusion, I have another custom post type which uses a similar query on a metabox date field and that works just fine.

It must be simple but it’s confusing the hell out of me!

Is the problem when viewing the CPT archive page?

Did you ever sort this out? What was the solution?