Entry into a DateTime column

Posted by: paulbowman3000 on 8 September 2017, 2:00 pm EST

  • Posted 8 September 2017, 2:00 pm EST

    <P>My users have reported to be a problem with the way the Farpoint grid handles date entry in UK locales dd/mm/yyyy.</P>
    <P>If I enter a date of 29/06/2009 tab away to accept it then return to enter a date of 31/07/2009 the cell will stop me from entering the '1' as there are not 31 days in June to make the control function correctly I need to change the month first which is awkward for a user.</P>
    <P>Is there a way for me to influence how the DateTime control validates dates?</P>
  • Replied 8 September 2017, 2:00 pm EST

    <p>Paul,</p><p>If I have understood the issue correctly,then the behavior you are seeing is intended behavior.When you have the entire date selected in editmode and type a number,
    the date that was in the cell is removed (overwritten) and since this
    is a DateTime field and there has to be a valid date in the editor at
    all times, the editor uses the default value for the editor (usually
    today's date) and fills in the parts of the editor that are not valid
    with values from this date.</p><p>You may test the same by entering an invalid date value (30 or 31) for the month of February. Alternatively, you can edit a date time cell type by using the Pop calendar.</p><p>Thanks<br></p>
  • Replied 8 September 2017, 2:00 pm EST

    <p>Hi Suresh,</p><p>Thanks for your reply. OK I can see your answer and if the date format was mm/dd/yyyy it would be OK as the month would be known and the day element can be validated correctly. However if the date format is dd/mm/yyyy the month is not known immediately therefore the control needs to be a bit more flexible with its validation. The control is not particularly usable if the user has to enter the month then go back and enter the day of the month and the popup editor is not helpful if the user is batch entering dates.</p><p>So my question remains is there away for the datetime column editor to be more flexible without sub classing?</p><p>Thanks for your help.</p><p>Paul <br></p>
  • Replied 8 September 2017, 2:00 pm EST

    <p>Paul,</p><p>As informed the exhibited behavior is intended behavior from Spread, however it has been added as enhancement request for the next version.</p><p>Thanks<br></p>
Need extra support?

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

Learn More

Forum Channels