Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Special datetime function needed
Message
From
09/01/2007 02:49:35
 
 
To
09/01/2007 02:41:03
Albert Beermann
Piepenbrock Service Gmbh & Cokg
Osnabrück, Germany
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Database:
MySQL
Miscellaneous
Thread ID:
01183702
Message ID:
01183705
Views:
16
This message has been marked as the solution to the initial question of the thread.
>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

To get the number of seconds:
?Datetime(2007,7,15)-Datetime(1601,1,1)
To get the number of nanoseconds, multiply by 1.000.000.000 (european style, 1,000,000,000 US style), which gives the formula
?(Datetime(2007,7,15)-Datetime(1601,1,1))*1E9
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform