Custom Columns - Input for Date/Datetime Columns

Help & Support
1

Hi there,

currently I am extremly confused how to fill the input correctly custom date or datetime columns.
I am using javascript for my scripts and there seems a major difference between how date and time is handled within javascript and dopus.

As far as I have analized the behaviour, javascript uses a epoch time based on milliseconds since ~1970, and dopus uses epoch time based on days (?) since 1899?!.

Could someone give an example how to convert a standard javascript date object to the input dopus needs for the custom date/datetime?

thanks and bye

Miran

2

Opus date to JScript date:

jsDate = new Date(opusDate);

JScript date to Opus date:

opusDate = jsDate.getVarDate();

(They are not really "Opus" dates. The date format is defined by COM / Active Scripting.)

3

now I feel stupid :confused:

many Thanks

4

Don't feel stupid; it's easy once you know what to do, but what to do is far from obvious.