Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
rajendra1918
Contributor

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

Re: Remove Timestamp

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

Re: Remove Timestamp

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

antoniotiman
Honored Contributor III

Re: Remove Timestamp

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

SET DateFormat='YYYY-MM-DD';

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

Regards,

Antonio

rajendra1918
Contributor

Re: Remove Timestamp

Both conversions working fine.

Thanks a lot

Regards,

Rajendra

kamal_sanguri
Valued Contributor

Re: Remove Timestamp

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
Honored Contributor III

Re: Remove Timestamp

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
Contributor

Re: Remove Timestamp

Done.

Thanks for Suggestions

Regards,

Rajendra