Your Privacy Matters: We use our own and third-party cookies to improve your experience on our website. By continuing to use the website we understand that you accept their use. Cookie Policy
430
formatting datetime cols in a grid
posted

I want to format datetime cols in the grid as mm/dd/yyyy hh:mm tt in the cell but can't figure out the correct format to use.  I have been using the mask input on the datetime input control as a guide.  Any help wold be appreciated

 

  • 469350
    Suggested Answer
    Offline posted

    If you want to format a date in the grid, you should use the Format property of the column. The formats are based on the DataType of the values in the cells and you should consult Microsoft's documentation for the possible formats you can use:

    Standard Numeric Format Strings

    Custom Numeric Format Strings

    MaskInput is for masking input when the cell is in edit mode. The Infragistics documentation lists all of the possible mask characters that are supported. It looks to me like that mask you have here is perfectly fine: "mm/dd/yyyy hh:mm tt".