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..

[Frank_Hartmann]

Try that:

date(floor(Timestamp(now()))) as Timestamp

hope this helps

[Anil_Babu_Samineni]

From given data you are expecting this? 28/02/2017 0:00:00.

You can use this  =Timestamp('2017-02-28T00:00:00+00:00')

[khaycock]

I tried this in the script..

timestamp(DueDate),

and it returned a null value instead

[Anil_Babu_Samineni]

I tried this and it return image

LOAD Timestamp(DueDate) as DueDate Inline [

DueDate

2017-02-28T00:00:00+00:00

];

[annafuksa1]

try to use

date:

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

Inline [

DueDate

2017-02-28T00:00:00+00:00

];

[yoganantha321]

Hi Karthryn,

I have tried with the following

date(DateEntering,'DD/MMM/YYYY') as DateEntering and got output as the below image

I think this is useful for you

[khaycock]

It giving me a blank response

[Frank_Hartmann]

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

[CarlosAMonroy]

Hi Kathryn,

Try this:

date(left(DateField,10),'DD/MMM/YYYY')

thanks,

Carlos M