Trim string after the first 10 characters

[justcotto]

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

[hopkinsc · Accepted solution]

Hi,

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

then do your date conversion?

[hopkinsc]

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

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