Tweet
ok, i would like to show current time +10 hours on my form. actually, i don't even need the time, i have it show julian day (day of the year.. for example today is the 158 day). i use this for my control source
=Format(Date(),"y")&"day"
the problem is it updates off of the system clock, and we use zulu time which is 10 hours ahead. so in other words. i would like it to change the julian day at 2pm everyday instead of midnight.
i hope someone knows because i am stuck.
=Format(Date(),"y")&"day"
the problem is it updates off of the system clock, and we use zulu time which is 10 hours ahead. so in other words. i would like it to change the julian day at 2pm everyday instead of midnight.
i hope someone knows because i am stuck.