Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a calendar represented via slider. When a date range is selected from the slider, the default Current Selection Display is xxx of xxxx. Is there a way to format the selection to display the appropriate date range selected ie. Mar 21, 2010 to Mar 30, 2010 ? I was thinking of using a text box to properly set the display - GetFieldSelections([date here]) and including a min/max but unable to get the desired output. Any idea is appreciated.
You should be able to display in a text object with the expression:
=min(DateField) & ' to ' & max(DateField)
-Rob
You should be able to display in a text object with the expression:
=min(DateField) & ' to ' & max(DateField)
-Rob
Thanks for the tip. I have revised the expression to check for nulls, add a column description and format the dates accordingly.
=if(Isnull(GetFieldSelections([DateField)])),'','Delivery Date : '&Date(min([DateField]),'YYYY-MM-DD') &' to '&
Date(max([DateField]),'YYYY-MM-DD'))