Display actual date selection in 'Current Selections'

[#1]

Hello,

I have calendar object which allows the user to select a date range. The expressions for 'From' and 'To' are as follows.....

From

=min({1}Date)

To

=yearend(date(today()))

The problem I having is that when the user selects a date range the display in the 'Current Selections' are shown as numbers. This is a common feature in excel but I can't seem to correct this. See attached for some screen shots.

Any ideas please?

[vincent_ardiet · Accepted solution]

If it's only to show the selection (and not use the other functions of the current selection box), you can create your own box with a textbox. We have done this for our users creating a sentence in english because they were lost with the standard object.

[#3]

Thanks Vincent, I think that would resolve the issue!

I've used the following expression within a list box and it works well:

='Date range selected: ' & 'From ' &Date(min({1}Date)) & ' To '&Date(yearend(date(today())))

Regards!

[nagaiank]

In the Calendar object, change the format to 'Date' in the Number tab of the properties window to see the date range as dates instead of numbers in the Current Selections box.