The sorting is only applied to the sample of data loaded on your screen. If you need to view the results for the oldest or latest dates available in your dataset, you need to save your customised view and find it in your Snowflake account, connect to it via an external tool, or download the view.
For further information on the topic, see the article How does the sample data preview work?