date function

[#1]

HI,

I had a table with hire date(dd-mm-yy hh:mm:ss)

I use Month(hiredate) as Month

the month field contains only jan, feb.oct,nov,dec

but

i want all months in the listbox

see the below image

[#2]

Hi,

If you use month(hiredate) it will show you only those months which are available in data. Can you please check data in the column hiredate.

please share sample app.

Regards

Shruti

[ajaykumar1]

I hope the month function will gives the result based on the field data which you used like Hiredate.

To get all the months you have to pull the month field which you have in the master calender.

Rgds,

Ajay

[ajaykumar1]

Hi Anil are you from Mathukumalli?

Rgds,

Ajay

[its_anandrjs]

The Month field value depends on your hiredate data if there is data only for jan, feb.oct,nov,dec then you not get data for all months. If you need month values like for all months(Jan,Feb,Mar,Apr...Dec) then add master calendar in the data model.

[PrashantSangle]

Hi,

As Shruti said it is showing you only those months which are available in data which is true.

But if you still want to show all month in ListBox.

Just Create New Inline table

Like

LOAD * INLINE [

    Month

    Jan

    Feb

    Mar

    Apr

    May

    Jun

    Jul

    Aug

    Sep

    Oct

    Nov

    Dec

];

and Use this Month as List box.

Then It will gives you transactions for Those month which is available in your table and Other Value For other show zero or Null

Regards,

PS

[MK_QSL]

Check enclosed file..

[MK_QSL]

Check enclosed file..

[#9]

hi ur native place plz?

i am frm vinukonada

& w r u ding?

mail:

gkc9908@gmail.com