Coercing text time value to DATETIME field

Classic Servoy
1

I have a text field with a time value (hh:mm:ss format) from a FMPro database that I want to import into a Servoy DATETIME field. How do I coerce a time value into a DATETIME field? I’m using dt= new Date(dateenteredtext) function for corecing a text date to a DATETIME field, but there appears to be no new Time() function.

2

there is no special time field. you have to store it as a date (with only the time portion)

3

OK. How is that done with no date? Can you please give and example?
the field I have to work with, starttime, is a text field formattted as hh:mm:ss.

4

i think you have to attach a date portion to it..

new Date(‘01/01/1990 10:15:55’);

and on the place of 10:15:55 youre time.

5

var timeString = “14:05:03” //just a random string

// convert timeString to an array >> looks like this: timeArray =(14,05,03)
var timeArray = timeString.split(“:”)

//Converting strings/nrs to a date >> new Date(95,11,17,3,24,0) //YY,MM,d,H,m,s
//new Date() is a javaScript date Object that can be manipulated in many ways
//(also check out the JSLib in the Servoy method editor)
dateColumnInDateBase = new Date (00,00,00,timeArray[0],timeArray[1],timeArray[2])

// 1/1/1900 2:05:03 PM is actually stored inside the database
// also check out the Servoy help file using formats YY,MM,d,H,m,s!
//(search for “importing dates”)