• Registered: 2014-09-04
  • Posts: 98

Topic: date picker - not saving date and time

it seems it only saves the date only not the time - is there an option to save both?  My descending sort by date sorts like this

9/16/14  this was done at 8 am
9/16/14 this was done at 10 am
9/16/14 this was done at 3 pm
9/15/14 this was done a 8 am
9/14/14 this was done at 2 pm

and it should sort

9/16/14 this was done at 3 pm
9/16/14 this was done at 10 am
9/16/14  this was done at 8 am
9/15/14 this was done a 8 am
9/14/14 this was done at 2 pm

  • Registered: 2014-02-14
  • Posts: 10,294

Re: date picker - not saving date and time

1. You should use field type DATE/TIME in database

2. For example, you need to keep the database at the same time the time and date for that you need to connect two components, one of which is a major, and display time, and the second slave, his name must be entered in the Calendar property of the main component, the component can be subordinate Date / Time with the property Kind = Date, or Calendar component.

A slave component, there is no need to define properties TableName and FieldName, it should be done only at the main component.

Dmitry.
  • Registered: 2014-09-04
  • Posts: 98

Re: date picker - not saving date and time

thanks, the Date/Time does what I need