Servoy Forum

by **Harjo** » Fri Jan 30, 2004 3:41 pm

Is it possible to convert a DATETIME, to a unique number?
and vice versa?
unique number to a DATETIME?

Like in Filemaker you can do with date to number and number to date!

by **IT2Be** » Fri Jan 30, 2004 3:46 pm

DateTime already is a unique number...

Use yourdatetime.getMilliseconds();

by **Harjo** » Fri Jan 30, 2004 4:00 pm

I don't get it!

this does not work!
It always returns value: 417

:?:

field: setvervaldatum (DATETIME) dd-MM-yyyy
calculated field (INTEGER): return setvervaldatum.getMilliseconds();

by **IT2Be** » Fri Jan 30, 2004 4:09 pm

With me, under os x I don't get the same value like you but the value is very low and bouncing up and down instead of adding up...

In JavaScript this really is the function we need for this so I think there is something wrong here

by **bcusick** » Sat Jan 31, 2004 1:42 am

HJK wrote:I don't get it!

this does not work!
It always returns value: 417

field: setvervaldatum (DATETIME) dd-MM-yyyy
calculated field (INTEGER): return setvervaldatum.getMilliseconds();

Try this:

calculated field (INTEGER): return setvervaldatum.getTime()

returns: 1075449600000 (date: 01/30/2004 [MM/dd/yyyy])

Bob Cusick

Servoy Forum

date to number

date to number

Who is online