Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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..
you need to use this
LOAD date(Date#(left(DueDate,10) ,'YYYY-MM-dd'))as DueDate
Try that:
date(floor(Timestamp(now()))) as Timestamp
hope this helps
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')
I tried this in the script..
timestamp(DueDate),
and it returned a null value instead
I tried this and it return image
LOAD Timestamp(DueDate) as DueDate Inline [
DueDate
2017-02-28T00:00:00+00:00
];
try to use
date:
LOAD date(Date#(left(DueDate,10) ,'YYYY-MM-dd'))as DueDate
Inline [
DueDate
2017-02-28T00:00:00+00:00
];
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
It giving me a blank response
date(Date#(left(DueDate,10) ,'YYYY-MM-DD'),'DD/MMM/YYYY')
Hi Kathryn,
Try this:
date(left(DateField,10),'DD/MMM/YYYY')
thanks,
Carlos M