Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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;
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;
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;