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
535
Split Date and Time
posted

I have noticed that the combined date time editor is a bit tricky to use and prone to end user frustration.  Is there a way I can split a date_time field in a databse into 2 columns in the grid?  One for date and one for time?

Peter

Parents
No Data
Reply
  • 455
    posted

    I think you don't need to actually split it. Just take the column out of database twice like

    SELECT dateDOB AS date1, dateDOB AS date2 FROM tableUser

    and then set the Format property of each column to ask each column to display either the date or the time.

Children