result of date functions, applies only formatting?

[#1]

Hi

I have data containing the date of the entry. I would like to provide a month selection and used

load date(mydate, 'MMM-YY') as Month

to have the month in the facts available.

When I create a listbox it shows duplicated month's, an entry for each day.

It looks like my date function applied only a format property to the value but did not actually return the string 'Jan-10'.

How can I make the value 'Jan-10' available in the fact?

Juerg

[#2 · Accepted solution]

Hi,

Y0u may want to use the Monthname(mydate). It will return you the month and year.

Nimish

[#3]

Thanks Nimish

So do you also have this understanding that I only modified the format string but not the value of the field?

Juerg