Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
justcotto
Contributor III
Contributor III

Trim string after the first 10 characters

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

 

1 Solution

Accepted Solutions
hopkinsc
Partner
Partner

Hi,

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

then do your date conversion?

View solution in original post

2 Replies
hopkinsc
Partner
Partner

Hi,

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

then do your date conversion?

View solution in original post

hopkinsc
Partner
Partner

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

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