Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

Are Dates Calculated on the Server or Workstation?

April 26, 2017calculated dates server Workstation

0

Posted

Are Dates Calculated on the Server or Workstation?

1 Answer

0

Posted

For views, it’s easy. Views are executed by the server so everything comes from the server, including @username and other functions that trip people up. For other date and time fields though, it is very confusing. Here is a breakdown on date calculations elsewhere: “Date Field Types” are mainly responsible for where the date will be generated. 1. When the Date fields are Editable: @Created: 11/02/93 02:25:02 AM @Now: 11/02/94 02:29:57 PM @Today: 11/02/94 @Yesterday:11/01/94 @Tomorrow:11/03/94 @Modified: 11/02/93 02:29:50 AM @Accessed 11/02/93 02:29:50 AM Result: a) @Created, @Modified, @Accessed come from the server. b) @Now, @Today, @Yesterday, @Tomorrow come from the workstation. c) First time @Modified date comes from the workstation. 2. When the Date fields are Computed: @Created: 11/02/93 02:27:46 AM @Now: 11/02/94 02:29:48 PM @Today: 11/02/94 @Yesterday:11/01/94 @Tomorrow:11/03/94 @Modified: 11/02/93 02:30:13 AM @Accessed 11/02/93 02:28:43 AM Result: a) @Created, @Modifies, @Acce