How to identify CPU time

[Guest]

How do you program to include UTC time (GMT) as a default
value when entering default value?

 

[hcj]

You can use =Now()-(zone), where zone is your local time
zone (e.g. Central Daylight Time is -5). However, I don't
know how to detect the zone that your CPU clock is using,
and that changes when you move back and forth from
standard to daylight time if you have your clock set to
update itself automatically. Maybe someone else can help
you there. Otherwise you'd have to remember to change the
zone value whenever the switch is made OR (worse) if you
have a networked database that crosses time zones OR if
you transport the database to another time zone and forget
to change the zone value. Far from a perfect answer, but
perhaps it's a start.

 

[Guest]

cool- thanks.

-----Original Message-----
You can use =Now()-(zone), where zone is your local time
zone (e.g. Central Daylight Time is -5). However, I don't
know how to detect the zone that your CPU clock is using,
and that changes when you move back and forth from
standard to daylight time if you have your clock set to
update itself automatically. Maybe someone else can help
you there. Otherwise you'd have to remember to change the
zone value whenever the switch is made OR (worse) if you
have a networked database that crosses time zones OR if
you transport the database to another time zone and forget
to change the zone value. Far from a perfect answer, but
perhaps it's a start.


.