Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
I got it.
Capitalize(Min(Date(data, 'MMM'))) & ' ' & 'a' & ' ' & Capitalize(Max(Date(data, 'MMM')))
='Data from ' & month(min(YourDateField)) & ' to ' & month(max(YourDateField))
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'))
I had tried something similar, but it is not working.
What date field is the user selecting from? Can you post a sample qvw?
I got it.
Capitalize(Min(Date(data, 'MMM'))) & ' ' & 'a' & ' ' & Capitalize(Max(Date(data, 'MMM')))