How to extract date,time,day,year,month from a single field.

[vinod22kv]

Hi,

I have a field named as Date_Time and form that i have extract date,time,day,year,month.Can you please help me out. and the data in the excel is given bellow.

  Date_Time

Fri, 11 May 2018 10:09:06 +0000

Fri, 11 May 2018 10:35:59 +0000

Mon, 14 May 2018 07:07:09 +0000

Mon, 14 May 2018 07:43:32 +0100

Mon, 14 May 2018 08:13:21 +0100

Mon, 14 May 2018 09:21:16 +0000

Mon, 14 May 2018 10:00:59 +0100

Mon, 14 May 2018 11:01:24 +0000

Thanks and Regards,

Vinod.

[YoussefBelloum]

Hi,

maybe try this on the script:

TABLE

LOAD

.

Date(Timestamp#(DATE_TIME,'DDD DD MMM YYYY hh:mm:ss.fff'),'DD/MM/YYYY') as Date

FROM...

and tell me what you see on a listbox using Date field for example

[vishalarote · Accepted solution]

Try this,

LOAD *,

SubField(Date_Time,',',1) as Day,

mid(Date_Time,6,2) as Date,

mid(Date_Time,8,4) as Month,

mid(Date_Time,12,5) as Year,

Mid(Date_Time,18,9) as Time

Inline [Date_Time

Fri, 11 May 2018 10:09:06 +0000

Fri, 11 May 2018 10:35:59 +0000

Mon, 14 May 2018 07:07:09 +0000

Mon, 14 May 2018 07:43:32 +0100

Mon, 14 May 2018 08:13:21 +0100

Mon, 14 May 2018 09:21:16 +0000

Mon, 14 May 2018 10:00:59 +0100

Mon, 14 May 2018 11:01:24 +0000

](delimiter is '');

[vinod22kv]

It is not working.

[YoussefBelloum]

You can take vishal solution. It is working