about class() function

[#1]

here in Class() what is[value] ???  and why we are using 10??

plese give me the answer.....

    those data should be coming in between <= and < (or) >=  and < like that.

       what is the  main theme of class() function??

please tell me..... 

[#2 · Accepted solution]

class function is used for classification of expression

class(value,10)  syntax returns like   this    value<=x<10   here  10 is the interval

in your scenario     first value is 10

then  10<=x<10

next 11       gives like    1<=x<10  , 11<=x<20  your value between  11  its in between of 11<=x<20

like this all ....

i hope u understood

[#3]

hello,

       I have another doubt.not class().

        i.e  we have 2 txt files .one file date in MM/DD/YYYY format.

              another txt file date in YYYY/MM/DD format.

               combining these 2 txt files. we will get the date format as DD/MM/YYYY.by using Date# function.

     How to get it in DD/MM/YYYY format?? by using "Date#".

  please send me answer..............

[#4]

Hi,

Class function will divide the values as you gave here 10

here it will divide like

1>=x<10

11>=x<20

21>=x<30

31>=x<40

41>=x<50

in 1 field only.this is just like a bucket field.

and your second scenario

Date(date#(datefield,'DD/MM/YYYY'),'DD/MM/YYYY') as New_Date

[#5]

try this it works ,

date(date#(yourdatefield,'mm/dd/yyyy'),dd/mm/yyyy)

vishnu priya pls close this thread and raise a new question

endhukante ila raise chesthe we may forget to see ur question.

[#6]

how to close thread??

[#7]

that date function is not working....

please help me for this.....

[#8]

click on ur question (open your inbox>right click on your question>open in new tab > u will get options liek correct and helpful answers

[#9]

try with out comma

date(date#(yourdatefield,'mm/dd/yyyy')dd/mm/yyyy)

if not worked pls post some sample data

[#10]

this date function not working.

please give me another scenario....