Hi:
I am having a problem with Date+Time values ... not being consistent.
In the on Click section of one of my Stateless Forms, I have ...
timeNow = zoho.currenttime;
insert into Work_Orders
[
...
...
WhenOrdered = timeNow
...
...
]
openUrl("#Form:Thank_You_For_Your_Order?WorkOrderWhenOrdered=" + timeNow, "same window");
... and in the Thank_You_For_Your_Order Form, I have a Date+Time field that gets populated with the value passed in timeNow as part of the url.
The Date+Time displayed in the Thank_You_For_Your_Order Form displays the correct Date and Time
But when I display the Work_Orders View ... the values in WhenOrdered field (of type Date+Time) are ahead by 3 hours ... even though it says at the bottom that ...
* All Times are in EDT
By the way, I am running this App from a computer in the Eastern Time Zone ... and the Pacific Zone (where ZOHO Computers are located) is 3 hours behind (not in front) of my place.
I am capturing zoho.currenttime into a variable first ... because I want to place the exact same values in the Record as I pass to the next Form.
Can someone explain this descrepancy ... I don't want to hard code a number (to subtract) just to make the values what they should be ... as User could be in any of many different time zones.
Gaev