Date functions

[#1]

Hi ,all i want to make date into partitions also rejoin that partions ,

Give me some idea about date function

[MK_QSL]

Unclear what actually you want !!!

[its_anandrjs]

Suppose you have date 28042014

and you have separate them like below

=Right(28042014,4) as Year

=Mid(28042014,3,2) as Month

=Left(28042014,2) as Day

And then you can use all this to make date like

=Makedate( Right(28042014,4) , Mid(28042014,3,2) ,  Left(28042014,2) )

If you want like this otherwise share your sample or please explain more.

You can create date fields like

LOAD

Day(Datefield) as Day,

Month(Datefield) as Month,

Year(Datefield) as Year,

'Q' & Ceil(Month(Datefield)/3) as Quarter

From Location;

[jagannalla]

Hi Uday,

You can split your date using lot of techniques. Few are,

Month(DateField) as Month

Year(DateField) as Year

Day(DateField0 as Day

or

Date(DateField,'YYYY') as Year

Date(DateField,'MM') as Month or using 'MMM'

Date(DateField,'DD') as Day

Like this in qlikview we had lot of techniques.

But what are you expecting.

Hope it helps you!!!

Cheers!!!!!!

Jagan

[#5]

If i have one year data,here i want to partition this one year data in to various parts , i want to use some funtion to partition the date as 4month or 6months,how it can be using some funtions,please reply

[MK_QSL]

Can you provide some sample data along with your expected result in excel file.

Looks like your requirement is not difficult to achieve but I am unable to understand it properly.

[#7]

Thanks for your reply ,but am asking how to partition the date in to quarter,4month ,6months,9months ,

[its_anandrjs]

If you provide any sample will be better or if i am understand you can make the Flags in the load script and partition the date fields and then use in the front end

Like

Load

If(NumMonth >=1 and NumMonth <= 5,'Month between 1 and 5 '

If(NumMonth >5 and NumMonth <= 12,'Month between 6 and 12')) as  MonthFlag

from Location;

[#9]

how we can spillt date using "ceil" function,please answare

[MK_QSL]

Considering that you have TimeStamp

Date(Floor(YourTimeStampField)) as Date

Time(Frac(YourTimeStampField)) as Time