472,328 Members | 1,416 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,328 software developers and data experts.

modied now() with time zones

Hi All:

I´m developing a web app to be used several time zones away from where the
server is located. I would therefore like to develop a function that
substitutes now() both for dates / times, takes into account the time
difference and whether or not summer summer is in force, as well as date
corrects when the server time and the "local time" is on different sides of
midnight (For example "2006-02-01 03:00:00" CET would be would "2006-01-31
20:00:00" EST during the summer).

The server is on Central European Time (CET) and the app will be used in a
area using Eastern Standard Time (EST), the latter being seven hours behind
when summer time is in force but only six behind during the winter.

So regardless of the time of the year I would like to be able to do things
like this with a function called "nowlocal()":


dim currenttime, current as string
currenttime = hour(nowlocal()) & ":" & Minute(nowlocal())

currentdate = Day(nowlocal()) & "/" & Month(nowlocal()) & "/"

etc, etc

Any suggestions will be highly appreciated.


Apr 4 '06 #1
0 1309

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

by: lduperval | last post by:
Hi, I`m trying to do date calculations in three types of time zones: local, GMT and specified. The issue I am facing is that I need to be able to...
by: heirou | last post by:
I'm a novice in this subject....I've made a database that requires a time conversion. For example, if local time is 1200, determine the time in...
by: Rebecca Smith | last post by:
Today’s question involves two time text boxes each set to a different time zone. Initially txtCurrentTime will be set to Pacific Time or system...
by: WebCM | last post by:
There is a function: http://paste.ubuntu.com/21865 It needs GMT date in YYYY-MM-DD HH:MM:SS format - in SQL: datetime. If date is the same as...
by: tammygombez | last post by:
Hey fellow JavaFX developers, I'm currently working on a project that involves using a ComboBox in JavaFX, and I've run into a bit of an issue....
by: tammygombez | last post by:
Hey everyone! I've been researching gaming laptops lately, and I must say, they can get pretty expensive. However, I've come across some great...
by: concettolabs | last post by:
In today's business world, businesses are increasingly turning to PowerApps to develop custom business applications. PowerApps is a powerful tool...
by: teenabhardwaj | last post by:
How would one discover a valid source for learning news, comfort, and help for engineering designs? Covering through piles of books takes a lot of...
by: CD Tom | last post by:
This happens in runtime 2013 and 2016. When a report is run and then closed a toolbar shows up and the only way to get it to go away is to right...
by: CD Tom | last post by:
This only shows up in access runtime. When a user select a report from my report menu when they close the report they get a menu I've called Add-ins...
by: Naresh1 | last post by:
What is WebLogic Admin Training? WebLogic Admin Training is a specialized program designed to equip individuals with the skills and knowledge...
by: jalbright99669 | last post by:
Am having a bit of a time with URL Rewrite. I need to incorporate http to https redirect with a reverse proxy. I have the URL Rewrite rules made...
by: Matthew3360 | last post by:
Hi, I have a python app that i want to be able to get variables from a php page on my webserver. My python app is on my computer. How would I make it...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.