sollte das nicht so sein:

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

Viele Gruesse

Peter


>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