topic Date and time split in QlikView

Date and time split

Tue, 29 Oct 2013 09:20:16 GMT

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 — Tue, 29 Oct 2013 09:27:35 GMT

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

saumyashah90 — Tue, 29 Oct 2013 09:28:42 GMT

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

israrkhan — Tue, 29 Oct 2013 09:37:13 GMT

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 — Tue, 29 Oct 2013 09:39:01 GMT

see attached document.

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