date formula

[JoseGarcia]

Hi there,
I would like to show the calendar date selected on a text box on month year format.
The issue I have is that when a whole month is selected, I am unable to get the Month and year to show in the text box.

I have used a vast array of formulas, but unable to get a good result.

Can anyone help? 🙂

=RangeOnly (Dual(Year([DateReportDate])&'-'&Month([DateReportDate]),MonthStart([DateReportDate])))

Thanks a million for your support.

Jose

[QFabian]

hi, try this :

= monthname(DateReportDate)

[JoseGarcia]

Fabien, formula works on single day selection.
When you do multiple days selection such as 31 days. It does not work. 😞

Any ideas?