Posted 8 September 2017, 1:44 pm EST<p>Hello, </p><p> </p><p>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.</p><p> </p>
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
Replied 8 September 2017, 1:44 pm EST<p>Hello,</p><p> </p><p>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</p><p>Hope this helps. </p><p>Thanks,</p><p>Suresh </p>
Replied 8 September 2017, 1:44 pm ESTSince 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.<br>
Replied 8 September 2017, 1:44 pm EST<p>Thank you suresh </p><p>I got it.</p><p> </p><p>Regards</p><p>Bharath <br></p>