"Data from [First month of selected period] to [Last month of selected period]"

[carolinne88]

Hello guys. I need a tip. I want to put in a text object the following information: "Data from [First month of selected period] to [Last month of selected period]".

Example: If I select the months February, March, April and May, in my text object would appear "Data from February until May".

Can anyone help?

[m_woolf]

='Data from ' & month(min(YourDateField)) & ' to ' & month(max(YourDateField))

[rubenmarin]

Hi, or to show full month name:

='Data from ' & date(min(YourDateField), 'MMMM') & ' until ' & date(max(YourDateField),'MMMM')

And Capitalize() to set first character in caps:

='Data from ' & capitalize(date(min(YourDateField), 'MMMM')) & ' until ' & capitalize(date(max(YourDateField),'MMMM'))

[carolinne88]

I had tried something similar, but it is not working.

[m_woolf]

What date field is the user selecting from? Can you post a sample qvw?

[carolinne88 · Accepted solution]

I got it.

Capitalize(Min(Date(data, 'MMM'))) & ' ' & 'a' & ' ' & Capitalize(Max(Date(data, 'MMM')))