Default NOW() time is sometimes wrong?

  • 1
  • Problem
  • Updated 5 months ago
  • In Progress
Hi everyone, 

I have a random issue where the default time is randomly changing from some of my users. It should default to NOW() and is correct most of the time. Even when the record is saved it is correct, however sometimes it reads incorrectly. 

See the below for reference... 


Can anyone please advise?

Photo of Matt Small

Matt Small

  • 1,182 Points 1k badge 2x thumb
  • frustrated & puzzled....

Posted 5 months ago

  • 1
Photo of Mike Dwyer

Mike Dwyer

  • 3,390 Points 3k badge 2x thumb
Some users? Are their timezone settings correct? However, that 57-minute difference may be a different issue...
Photo of Matt Small

Matt Small

  • 1,182 Points 1k badge 2x thumb
Hi Mike,

First thing we checked was the time zones and so on. I believe this is something else. 
Photo of Stephen Sells

Stephen Sells, Official Rep

  • 16,856 Points 10k badge 2x thumb
Are you able to further give clarity into when it does fail and when it works? Intermittency is the bane of support's existence. Do certain times work and others don't? Do you have any hunches? Etc.