AnsweredAssumed Answered

timestamp field

Question asked by Joe Harper on Feb 2, 2017
Latest reply on Feb 4, 2017 by Hemant Patil

Hi, i am trying to create a timestamp field for when a check box is ticked i want to capture the date and time of that action but i don't want the date and time to update when the record is modified or saved again just when a particular check box is ticked. currently i have: 

 

ifElse(equal($decision_maker_c,1),timestamp(today()),"")

 

This is giving me a timestamp in a "date time" field but the format is wrong. it is giving me dates like: 

 

01/17/1970 11:46pm

 

Also, when i click save on the lead the field is wiped and left blank.

 

Any advice on this?

Outcomes