Date and time split

[#1]

Hi all,

I have an unusal date field: 2008-05-29T11:00:00Z  I dont need the time on the end I just want to pull out the year, month and date as separte fields.

Can anyone offer an suggestions.  Ideally like to do this in the script so I can pass on to others.

Many thanks

Paul

[saumyashah90]

what you can do is
=Date(DateTimeField,'DD-MMM-YYYY';)

[saumyashah90]

If you have fixed format of this filed then you can also use subfield() function

[israrkhan]

Try Floor and date functions

like below

load *,

Date(Floor(DateTimeField), 'DD/MM'YYYY) As Date,

Year(Date(Floor(DateTimeField), 'DD/MM'YYYY) as Year,

Month(Date(Floor(DateTimeField), 'DD/MM'YYYY) as Month

from abc

Hope it helps

[bdunphy · Accepted solution]

see attached document.

uses left() on the date field to strip out the part you need