I have a sample dataset column into this format '2015-01-01' I want to re retrieve theose year whose months are June. What will be the query??

[#1]

I have a sample dataset column into this format '2015-01-01' I want to re retrieve theose year whose months are June. What will be the query??

Thanks.

Bibhuti

[sunny_talwar]

Every year has a June Month, not sure what you are trying to do? Do you want to extract June from each year in the script?

May be this:

LOAD YourFields,

          Date#(DateField, 'YYYY-MM-DD') as DateField

FROM Source

Where Num(Month(Date#(DateField, 'YYYY-MM-DD'))) = 6;

[MK_QSL]

What you mean by those years whose months are June. Can you please give more information on your requirements?

[Anonymous]

If it is for June only, at script try WhatSunny T

has suggested you else at UI you can try like this?

Assume at script,

month(date) as Month

=sum({<Month={'6'}>} Sales)  //This will give you June records only

[reddy-s]

Hi Bibhuti,

As Sunny Mentioned the month() function should help you achieve what you are looking for. In addition to that, make use of a master calender and other date functions to simplyfy your front end calculations like:

year()

week()

WeerName()

inYear()

inYeartoDate() etc.... Check the script manual for detailed info on all the date functions.

Thanks,

Sangram