/ Forums / Advansys Formativ / Creating Solutions with Formativ / Appointment duration from DateTime controls / Reply To: Appointment duration from DateTime controls

#7914
dgerisch
Participant

So I like the idea of using the visual forms designer, from some of the sample applications, it looks like I’m going to be able to get the fine-grained control I want. However, I’ve run into a slightly different problem now. With the old dialog, I was picking up date+times in a human-readable format, and using that for iTimePeriodBegin and iTimePeriodEnd.

Now that I’m using the visual forms designer, I get errors about an OLE something and not a valid long number. Doing an export of the form to a file shows that the .Date data needs to be in the form of 39386.4694906366 (instead of 10/31/2007 11:54:00)

Sure enough, plugging that real number into iTimePeriodBegin and iTimePeriodEnd lets the dialog display.

What is the formula for computing this date+time number?

-Or-

Can I make the object DatePicker: TDateTimePicker be happy with a human readable date?

Thanks!