Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Sr No, Date
1, 2021-01-31-
2, 2021-01-30-
3, 2021-01-29-
5 , 2021-01-27-
6, 2021-01-26-
7 , 2021-01-25-
8 , 2021-01-24-
9 , 2021-01-23-
10 , 2021-01-22-
HI
Try like
Load *, Date(Left(Date,10)) as D1, Date(Date#(Date, 'YYYY-MM-DD-')) as D2 Inline
[
Sr No, Date
1, 2021-01-31-
2, 2021-01-30-
3, 2021-01-29-
5 , 2021-01-27-
6, 2021-01-26-
7 , 2021-01-25-
8 , 2021-01-24-
9 , 2021-01-23-
10 , 2021-01-22-
];
Both will help to remove the - in date column