[Solved] Calc converts '05/04/1999 to date number

[morphingstar]

I downloaded a csv in which the date is in text form.
Could not find a function to convert to date (win10 number)
DATE text DATE TRANSACTION ID DESCRIPTION QUANTITY SYMBOL

05/04/2021 34591480999 Sold 24 LASR

I considered string extraction but could not find a way to convert concatenated to number.
Search "calc convert '05/04/1999 to date number" brought nothing.

Considering the age of csv file format a solution might exist.
Thanks for help.

[morphingstar]

solution lies in the structuring menu, shown below.

[Villeroy]

In the text import dialog you specify how to interprete data.
Language should be English (USA) because of the US dates. English (Canada) makes sense with currency symbol CAD.
The dates to be imported is not Y-M-D. It is M/D/Y.
With the right language setting you don't need column specific settings unless there are exceptions.