Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
rajendra1918
Creator
Creator

Remove Timestamp

Hi Friends,

I am using Qliksense 3.1 version. im trying to remove time stamp from below date.

Please help me , how to get this done.

Available Date format:

2017-05-30 18:22:12.201+05:30

Required Date format

2017-05-30

Regards,

Rajendra

1 Solution

Accepted Solutions
Anonymous
Not applicable

To get the first 10 characters use :

     left('2017-05-30 18:22:12.201+05:30',10)

But probably better to convert it Qlik Date format with :

     date(date#(left('2017-05-30 18:22:12.201+05:30',10),'YYYY-MM-DD'),'YYYY-MM-DD')

View solution in original post

6 Replies
Anonymous
Not applicable

To get the first 10 characters use :

     left('2017-05-30 18:22:12.201+05:30',10)

But probably better to convert it Qlik Date format with :

     date(date#(left('2017-05-30 18:22:12.201+05:30',10),'YYYY-MM-DD'),'YYYY-MM-DD')

antoniotiman
Master III
Master III

or, if You have also timestamp like 2017-1-6 ..............

SET DateFormat='YYYY-MM-DD';

Date(SubField(Date,' ',1))

Regards,

Antonio

rajendra1918
Creator
Creator
Author

Both conversions working fine.

Thanks a lot

Regards,

Rajendra

kamal_sanguri
Specialist
Specialist

Pls refer this, same solution can be applied at front end.

Date(Date#(Date,'YYYY-MM-DD hh:mm:ss.fff+05:30'),'YYYY-MM-DD')

oknotsen
Master III
Master III

If your question is now answered, please flag the Correct Answer (via the big "Correct Answer" button near every post) and Helpful Answers (found under the Actions menu under every post).

If not, please make clear what part of this topic you still need help with .

May you live in interesting times!
rajendra1918
Creator
Creator
Author

Done.

Thanks for Suggestions

Regards,

Rajendra