topic Re: How to split time and date? in QlikView

How to split time and date?

Fri, 27 Jun 2014 17:21:14 GMT

This is the format I have. Now I want to split into Year, Month Year, Date, Week, Month and Time.

Can anyone help me out please.

Re: How to split time and date?

venkatg6759 — Fri, 27 Jun 2014 17:26:52 GMT

For

Year use

Year(Fieldname)

MonthYear

monthName

Date use

date or date# or timestamp or timestamp#

Week use

Week(fieldname)

month and time

Use

Month (Field) &' '& Time(Field)

Re: How to split time and date?

Fri, 27 Jun 2014 17:31:15 GMT

Try

Year(field),Month(field),Date(),Week(),Time() correspondingly

Re: How to split time and date?

its_anandrjs — Fri, 27 Jun 2014 17:32:39 GMT

Try with the scripts

LOAD

DateColumn,

Date(Timestamp#(DateColumn,'MM-DD-YY hh:mm TT'),'MM-DD-YY') as NewDateColumn,

Year(Timestamp#(DateColumn,'MM-DD-YY hh:mm TT')) as Year,

Month(Timestamp#(DateColumn,'MM-DD-YY hh:mm TT')) as Month,

MonthName(Timestamp#(DateColumn,'MM-DD-YY hh:mm TT')) as MonthYear,

Week(Timestamp#(DateColumn,'MM-DD-YY hh:mm TT')) as Week,

Time(Mid(Timestamp#(DateColumn,'MM-DD-YY hh:mm TT'),10,5),'hh:mm') as Time;

LOAD * Inline

[

DateColumn

10-24-13 12:00 AM

10-25-13 12:00 AM

10-26-13 12:00 AM

10-27-13 12:00 AM

10-28-13 12:00 AM

10-29-13 12:00 AM

10-30-13 12:00 AM

];

Re: How to split time and date?

its_anandrjs — Fri, 27 Jun 2014 17:48:08 GMT

If you have perfect timestamp filed then use

Date(DateField) as NewDateColumn,

Year(DateField) as Year,

Month(DateField) as Month,

MonthName(DateField) as MonthYear,

Week(DateField) as Week,

Time(DateField) as Time

Re: How to split time and date?

maxgro — Fri, 27 Jun 2014 17:51:26 GMT

floor(field) to get the date

frac(field) to get the time