Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Vijayqlik4171
Contributor III
Contributor III

I have date structure i want to remove date ending '-' coloumn-

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-






















1 Reply
MayilVahanan

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

MayilVahanan_0-1644287586265.png

 

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.
Community Browser