Converting string to date from a table created by input

[LapinTerrible]

Hello,

Could you please explain why the script isn't generating dates in the 'StartDate' and 'EndDate' columns?

Table1:
Load * Inline [

TerrID, Name, Start, End

1, Wladimir, 01-01-2022, 01-01-2022

2, Paul, 01-01-2022, 05-05-2022

2, Mark, 06-05-2022, 01-01-2022

3, Janne, 01-01-2022, 01-01-2022

];

Table2:
Load
TerrID,
Name,
date(Start, 'dd-mm-yyyy') as StartDate,
date(text(End), 'DD-MM-YYYY') as EndDate
Resident Table1;

[LapinTerrible · Accepted solution]

Using date# was the answer:

Table1:
Load * Inline [

TerrID, Name, Start, End

1, Wladimir, 01-01-2022, -

2, Paul, 01-01-2022, 05-05-2022

2, Mark, 06-05-2022, -

3, Janne, 01-01-2022, -

];

Table2:
Load
Name,
TerrID,
date#(Start, 'dd-mm-yyyy') as StartDate,
date#(End, 'DD-MM-YYYY') as EndDate

Resident Table1;