Could you use $SERVERTIMESTAMP$?
$SERVERTIMESTAMP$ -------------------------------------------------------------------------------- For Date/Time fields, the current date and time on the server. For Time fields, the current time on the server. For Date fields, the current date on the server. Note: The $SERVERTIMESTAMP$ keyword is not expanded when default values are set. This allows the value to be set to the date and time (on the server) the form is submitted rather than the date and time the form is opened. Consequently, the literal keyword is displayed in the field before the request is submitted. On Mon, Oct 4, 2010 at 2:31 PM, Sanford, Claire < [email protected]> wrote: > Is there a way to force the $TIME$ function to use the server time? > > We were going to use this to do some very time specific analysis, but > found out that if Joe Blow had his time zone wrong on his machine it > would set the time incorrectly. > > $TIME$ = 12:30 PM > $TIMESTAMP$ = 2:30 PM > > Thanks! > > Claire Sanford > Information Systems Division > Memorial Hermann Healthcare System > Phone: 713 448 6035 > [email protected] > > > _______________________________________________________________________________ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are" > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"
