I should display the data by month wise

[Anonymous]

HI All,

To display the data's by month wise for example  Jan Feb Mar i have data only for month Feb month and the field with Date and time when i select Feb month i should display the data's for the Feb month. Can any one help on this.

Thanks & Regards,

sivakumar

[ashfaq_haseeb]

Hi

Try below in load script.

Load Field1,

Field2,

DateTimeField,

Date(Floor(DateTimeField)) as Date,

Month(DateTimeField) as Month

from table

Now use month in your front end to filter

Regards

ASHFAQ

[#3]

Hi sivakumar,

From your Date&Time Field work like this,

If it is text format,

Load

month(floor(date(date#(YourDate&TimeField,'DD-MM-YYYY hh:mm:ss') ,'DD-MM-YYYY'))) as Month

From source;