topic Re: Help: how to separate date and time in QlikView

Help: how to separate date and time

Wed, 13 Mar 2013 15:47:42 GMT

Hello Qlivers,

if I want to serarate date and time from a colume contained both date and time together. how do i do it??

thank you~~

This is a sample of the date colume.

none of the codes were actually not working,

but i actually figured out how to do it, Anyways guys, for future reference, here is what i have::

Date(date#(date(Floor(departure), 'DD/MM/YYYY'), 'MM/DD/YYYY'), 'MM/DD/YYYY') as OutputDate,

Timestamp(arrive-Floor(departure), 'hh:mm') as OutputTime;

Gabriel — Wed, 13 Mar 2013 16:34:41 GMT

Hi,

Give that there's no visual of teh Date & Time format from your data.

Try Date(Subfield(xxxx,1) as date

Time (Subfield(xxxx) as Time

It that didn't work then upload sample data.

Regards,

Gabriel

Wed, 13 Mar 2013 16:43:31 GMT

Hi Gabriel, here is what my date look like.

m_woolf — Wed, 13 Mar 2013 19:44:19 GMT

If your field is named MyField:

date(floor(MyField) as MyDate,

timestamp(MyField-floor(MyField) as MyTime,

Gabriel — Wed, 13 Mar 2013 20:49:48 GMT

Hi,

Try this code using LIST BOX

Right click anywhere in the sheet then New Sheet Object -> List Box -> Field pane select Expression -> then enter

=date(SubField(DateTime,' ',1)) click ok.

This will give you just the Date

Right click anywhere in the sheet then New Sheet Object -> List Box -> Field pane select Expression -> then enter

=time(SubField(DateTime,' ',2)) click ok.

This gives you the time part.

This works for me so it should work.

Regards,

Gabriel

CELAMBARASAN — Wed, 13 Mar 2013 21:36:02 GMT

Hi,

You Can create fileds like below

Date(Floor(DateTimeField)) As DateField

Time(Frac(DateTimeField)) AS TimeField

Hope it helps

Celambarasan