It does sort correctly; but the date ranges of the heatmap chart would become date serial number. Apparently the numeric value of the Dual function is displayed instead of the text value:
How can I display the date range text while internally using the WeekStart([OrderDate]) for sorting purpose? Please advise.