topic Trim string after the first 10 characters in QlikView

Trim string after the first 10 characters

justcotto — Wed, 06 Mar 2019 21:42:41 GMT

I have a column containing a date string with a trailing time stamp. I want to remove the time stamp. The time stamp appears after the 10th character.

After that I would like to convert the date format from YYYY-MM-DD to MM/DD/YYYY:

Date(Date#(PAYMENT_DATE,'YYYY-MM-DD'),'DD/MM/YYYY'),

Re: Trim string after the first 10 characters

hopkinsc — Wed, 06 Mar 2019 21:53:26 GMT

Hi,

Cant you do a left(timestamp,10) as date

then do your date conversion?

Re: Trim string after the first 10 characters

hopkinsc — Wed, 06 Mar 2019 22:02:48 GMT

If the original format is YYYY-MM-DD 00:00:00 then maybe this would work..

date(left(timestamp,10),'DD/MM/YYYY')