I have made a function, it's very limited, since it takes into account the Current time zone, and calculates the result based on that, so if a user from a differeant TZ of me, will open the field,, he will see a wrong local time for that account. Yes, this can be updated, and to calculate based on user names, and do a more complicated calculation (if anyone wants to take that initiative, go ahead). but for now, I made a date/time field, visible only to me.
I have made a function, it's very limited, since it takes into account the Current time zone, and calculates the result based on that, so if a user from a differeant TZ of me, will open the field,, he will see a wrong local time for that account.
Yes, this can be updated, and to calculate based on user names, and do a more complicated calculation (if anyone wants to take that initiative, go ahead).
but for now, I made a date/time field, visible only to me.
feel free to update this formula as you need
IF(CONTAINS("india:sri lanka:pakistan", LOWER(BillingCountry) ),NOW()+1/24*2.5,
IF(CONTAINS("vietnam", LOWER(BillingCountry) ),NOW()+1/24*6,
IF(CONTAINS("thailand", LOWER(BillingCountry) ),NOW()+1/24*5,
IF(CONTAINS("australia", LOWER(BillingCountry) ),NOW()+1/24*8,
IF(CONTAINS("new zealand", LOWER(BillingCountry) ),NOW()+1/24*9,
NOW())))))