Date Time Stamp

[khaycock]

I have a date/time stamp that has been given to me in this format: 2017-02-28T00:00:00+00:00

What do I need to put in the script to get rid of the time part?

So I want it to just show DD/MMM/YYYY..

[annafuksa1 · Accepted solution]

you need to use this

LOAD  date(Date#(left(DueDate,10) ,'YYYY-MM-dd'))as DueDate

[annafuksa1]

or you can use this

LOAD  date(Date#(left(DueDate,10) ,'YYYY-MM-dd'),'DD/MMM/YYYY') as DueDate