topic Re: Remove Timestamp in App Development

Remove Timestamp

rajendra1918 — Thu, 01 Jun 2017 05:44:06 GMT

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

Re: Remove Timestamp

Anonymous — Thu, 01 Jun 2017 16:16:20 GMT

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')

Re: Remove Timestamp

antoniotiman — Thu, 01 Jun 2017 17:12:20 GMT

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

SET DateFormat='YYYY-MM-DD';

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

Regards,

Antonio

Re: Remove Timestamp

rajendra1918 — Fri, 02 Jun 2017 05:40:01 GMT

Both conversions working fine.

Thanks a lot

Regards,

Rajendra

Re: Remove Timestamp

kamal_sanguri — Fri, 02 Jun 2017 06:00:43 GMT

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')

Re: Remove Timestamp

oknotsen — Fri, 02 Jun 2017 07:21:04 GMT

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 .

Re: Remove Timestamp

rajendra1918 — Fri, 02 Jun 2017 07:57:51 GMT

Done.

Thanks for Suggestions

Regards,

Rajendra