My insights on Date And Datetime fields
I would like to share my recent experience with Date fields and timezone. Scenario 1: Created a date field 'CustomDate__c'. I configured a validation rule which says , CustomDate__c > Today() Problem: There are different users from different timezones, who can update the record. So, when two users from different timezones say PST(UTC-8), SGT(UTC+8) try to update this record, assuming that Today is Feb 8 2016 according to SGT, SGT User updates 'CustomDate__c' to Feb 8 2016. Validation rule won't fire this time. Now, when PST user tries to update another field on the same record, this user encounters validation error as Today according to this user is Feb 7th 2016. Scenario 2: I had two date fields 'Submission Date' & 'Approved / Rejected Date' on an object. These fields get updated whenever record is submitted for approval & when record is approved/rejected using Field updates in Approval process. Field Updates are con...