RE: %timestamp ??

Thanks Barbara.

Your example is exactly the kind of thing that could stuff you up when
you least expected it. And, as my quote of the month suggests, 'accuracy
is everything'.

%TIMESTAMP it is :-)

Cheers

Jim



Jim Wiant wrote in MIDRANGE-L Tue, 21 Nov 2006:

I usually use MyTimeStamp = %DATE + %TIME and that gives me the

current

time (doesn't get the milliseconds though)

Hi Jim, much safer to use MytimeStamp = %TIMESTAMP.

If you also need the matching date and time, you could then do
   MyDate = %DATE(MyTimeStamp);
   MyTime = %TIME(MyTimeStamp);

Doing %DATE and %TIME separately, you might do the %DATE one side of
midnight and the %TIME the other side of midnight, giving you 24 hours
too early, say 
   2006-10-20-00.00.01
rather than either  
   2006-10-20-23.59.59
   2006-10-21-00.00.01

Fast is fine, but accuracy is everything. 
Earp, Wyatt
This message has been sent from Foodstuffs (Auckland) Limited ("Foodstuffs").

The information contained in this message and or attachments 
is intended only for the person or entity to which it is 
addressed and may contain confidential and/or privileged 
material. Any review, retransmission, dissemination or other 
use of, or taking of any action in reliance upon, this 
information by persons or entities other than the intended 
recipient is prohibited. If you received this in error, 
please contact the sender and delete the material from any 
system and destroy any copies.

The views and opinions expressed in this message may be those
of the individual and not necessarily those of Foodstuffs, 
and are not given or endorsed by it.

Please note that this communication does not designate an 
information system for the purposes of the Electronic 
Transactions Act 2002.