Remove Timestamp

[rajendra1918]

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

[Anonymous · Accepted solution]

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]

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

SET DateFormat='YYYY-MM-DD';

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

Regards,

Antonio

[rajendra1918]

Both conversions working fine.

Thanks a lot

Regards,

Rajendra

[kamal_sanguri]

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]

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 .

[rajendra1918]

Done.

Thanks for Suggestions

Regards,

Rajendra