Group By Date In Pivot Tables

I have Record a Macro and assigned 2 macros to 2 different buttons.
The first button sorts the list by company name, which is working fine.
However when I press the second button, although it should sort the list by payment date, the data on the cells are interpreted as number and text separately, and then sorted accordingly, which gives an inaccurate result.

When I try to sort the list by payment date manually by clicking Data>Sort (by payment date), a warning box appears and from here I choose "sort anything that looks like a number, as a number" and everything in sorted correctly.

Is there a possible way to embed the "sort anything that looks like a number, as a number" option into the recorded macro?

Note: (The data in the payment date column are in "text" format rather than date format, this is necessary because a Pivot Tables is also used to manage the data on this list and the dates should be in text format in order to filter properly in the pivot table)