Time Span column data type in True DB Grid

Time Span column data type in True DB Grid

Posted by: soniabluelupin-com on 27 September 2017, 8:56 pm EST

• 

  soniabluelupin-com

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 27 September 2017, 8:56 pm EST

  Hi

  True DB Grid need to show a time span column (hh:mm).

  Even though I have set the Number format of the column to Short Time, it considers column as “String” due to which on filtering below error is given -
  
  “Cannot interpret token “:” at position 12”.

  Snap shot attached

  

• 

  arpit-jain

  • Post Options:
  • Link
    Copy

  Posted 27 September 2017, 8:56 pm EST

  Hi,

  Apologies for the delay in the response.
  
  We could replicate the issue at our end as well. We have escalated the issue to the development team and will let you know as soon as there is any update. Tracking id for the issue is: 144552.

  Regards,
  
  Arpit Jain

• 

  soniabluelupin-com

  • Post Options:
  • Link
    Copy

  Posted 27 September 2017, 8:56 pm EST

  Thanks Arpit!

  Right now, I have implemented a work around where I have set the column as date time and set Number Format as “Short Time” and applied custom format for the column during editing as “HH:mm”.

• 

  arpit-jain

  • Post Options:
  • Link
    Copy

  Posted 27 September 2017, 8:56 pm EST

  Hi,

  Thank you for sharing the work around.
  
  We will update you as soon as the issue gets fixed and there is any update from the team.

  Regards,
  
  Arpit Jain

• 

  Pragati.Kaushik

  

  • Post Options:
  • Link
    Copy

  Posted 29 November 2017, 5:02 am EST

  Hi,

  This issue has been fixed in the latest release build which can be downloaded from here:
  
  http://prerelease.componentone.com/dotnet40/c1winforms/2017-T3/C1WinForms.4_4.0.20173.282.zip

  Thanks,
  
  Pragati