Date+Time values are not consistent ...

Date+Time values are not consistent ...

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