Setting min and max date for the date picker shown in the grid after double clicking the date type column.

Posted by: bharath-ron on 8 September 2017, 1:44 pm EST

  • Posted 8 September 2017, 1:44 pm EST



    I have a grid with two column. The first column being of the data type string has no issues the second column is of Date as the datatype. When i double click on the cell it shows the date picker as the pop up , my question is whether can i set the minimum and maximum date which for the date picke so that the user is not allowed to enter the date beyond that range.


  • Replied 8 September 2017, 1:44 pm EST



    You may set the maximum and minimum date for the column in question. If you are setting a column to be of DateTime, you will be presented with an option to set the MaximumDate & MinimumDate, so as per your requirements you may set the dates. Using this.option, one can not select/set a date other than one which is falling between the MaximumDate & MinimuDate.This can be easily done from SpreadDesigner as well as with the help of code

    Hope this helps. 



  • Replied 8 September 2017, 1:44 pm EST

    Since you are bound the columns data type is being set to DateTime for you but the Minimum/MaximumDate are not being set. You can either use the DataColumnConfigure event or set DataAutoCellTypes to FALSE and set up your celltypes manually to add in the Min/Max settings.
  • Replied 8 September 2017, 1:44 pm EST

    Thank you suresh

    I got it.




Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels