Albert,

Guten Morgen.

?DATETIME(2007,07,15,23,59)-DATETIME(1601,1,1)*10^7

will return time since 1.1.1601 0:00 in 100 nanos

Agnes
>Hello Everybody
>
>I have to set the accountexpires value in our active directory.
>I get the date, when a person will leave our company(25000 employees) from a SAP System.
>I found this in MSDN:
>The value in the AD "represents the number of 100 nanosecond intervals since January 1, 1601" !!!???
>
>For example:
>If a person leaves our company at 15th of july 2007, i want to calculate the needed value for 15.07.2007 (german date) 23:59:00
>But no idear ???????????
>
>Any help welcomed
>Best regards
>Albert